Turn a ChatGPT answer into spreadsheet rows
Every hour, asks ChatGPT for a list as JSON, splits it into items and adds one row per item to your Google Sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in the order it first runs them, and what it is for.
- 1OpenAIQuery modelAsks ChatGPT for the number of items you set, as a JSON array with one object per item and one key per column you listed.
- 2Google SheetsAppend rowAppends one row per item: the run's date and time, then each column's value in the order you listed, written as plain values.
How it works
What happens on each run, in plain English.
Describe what each item should be - 'quiz questions about world geography, each with its answer and a difficulty from 1 to 5' - and name the columns each item should fill. Every hour the workflow asks ChatGPT for that many items as a JSON array, one object per item with one key per column, reads the reply, and appends one row per item to your Google Sheet: the run's date and time first, then your columns in the order you listed them.
The reply is read defensively: code fences and any wording around the array are ignored, keys are matched whether or not ChatGPT changes their case or spacing, and a value it left out becomes an empty cell rather than a made-up one. Rows are only ever added, and values are written exactly as they arrived so none can become a formula. A reply that is not a list at all fails the run and says why, so an hour with no rows is never mistaken for a quiet one.
Before the first run, give the sheet a header row: 'Generated at' followed by your columns in the same order. Each run asks afresh, so over time similar items can come back; the first step sets how often it runs.
You May Also Be Interested In
Approve the outline, then the post, then publishTakes the next topic off your content plan, asks you to approve the outline, writes the post to it, and publishes only if you say so.
Read a whole site into spreadsheet rowsFinds the pages on a site from its sitemap or front page, reads each one, and adds a row per page to your sheet.
Weekly Reddit mentions digestFinds posts about your product in the subreddits you watch, filters out the coincidences and emails a weekly digest.Find the problems your market keeps raisingReads the subreddits your customers use, groups the complaints that keep coming back, and emails the ones with real evidence.
Start from a workflow that already works.
Add "Turn a ChatGPT answer into spreadsheet rows" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required