Full Social Media Automation AI images | IG, YT, TikTok, X, Threads, Pinterest with Make.com · published 26 November 2025
Play at 4:07 Watch on YouTube Social
How do I give each run the next fact from a Google Sheet?
I keep the facts in one sheet and the current number in another. Search rows returns the fact whose number matches, and Update a row adds 1 so the next run takes the next fact.
The cheap version is to ask an AI for the facts once, outside Make, and paste them. I asked for 50 random facts for a facts page. Each row has a number in front of the fact. Google Sheets, Search rows, on that sheet. I delete the filter and run once to confirm all 50 come back. I then set the filter to prompt number, equal to, the number from the counter sheet.
The counter is its own sheet. The title does not matter. The first value has to be 1. Search rows on that sheet returns 1. Update a row uses row number 2, because the number sits on row 2 under the header. The new value is that number plus 1. In Google Sheets the cell needs an equals sign in front, or it stores the text instead of the sum.
The first run returns one fact, the deepest place on earth is the Mariana Trench, and the counter becomes 2. The next run returns the next fact and moves the counter to 3. The image module uses that one fact as the prompt. The same numbering idea is How do I look up a numbered fact in Google Sheets from Make?