How to get a random row from Google Sheets with Zapier - Post random blog posts, quotes and more скачать в хорошем качестве

How to get a random row from Google Sheets with Zapier - Post random blog posts, quotes and more

Learn how to get a random row from Google Sheets with Zapier. You can use this to post random blog posts to social media (like a poor man's MeetEdgar), post random motivational quotes to you or your team and lots more. It's a great Zapier skill to learn. Learn how to save 100+ hours per month even if you've never used Zapier before in my course at https://jimmyrose.me/zapier-mastery/ Chapters 0:00 How to get a random row from Google Sheets 1:20 Google Sheet example to post random blog posts 1:37 Creating zaps 2:00 Creating a schedule trigger 3:00 Google sheet setup - new columns 5:00 Using ArrayFormula to auto populate the new columns 7:00 Looking up a random row in Zapier 1. Get the last row 2. Generate a random number between 2 & the last row number 3. Lookup the row Formulae for Row Number & Has Value. Add these into the 2nd row and customize the column letters as needed Row Number =ARRAYFORMULA(if(ISBLANK(B2:B),"",ROW(B2:B))) Has Value =ArrayFormula(if(ISBLANK(B2:B),"",TRUE)) Subscribe to learn about how to automate your business and marketing. Use the red button or sign up to get notified by email at https://jimmyrose.me/ ----------------------------------------------- Find me on the web: On the web: https://jimmyrose.me/ Facebook:   / jamesrosepage   Twitter:   / _jimmyrose   Instagram:   / getjimmyrose   LinkedIn:   / jamesrose0