Fill a spreadsheet with a ChatGPT-written list every hour

Every hour, has ChatGPT write a fresh batch of the list you describe and adds each item as a row in your Google Sheet.

EZEric Zeng · 1 workflow · Updated Nov 13, 2026

UsesGoogle SheetsOpenAI

Fill a spreadsheet with a ChatGPT-written list every hour

Run every hour.Run every hour.

Set request to blank.Set request to blank.

Set columns to blank.Set columns to blank.

Set itemsPerRun to 5.Set itemsPerRun to 5.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set sheetName to Sheet1.Set sheetName to Sheet1.

Set prompt to You are producing rows for a spreadsheet.Set prompt to You are producing rows for a spreadsheet. Produce exactly itemsPerRun items. Each item is: request Reply with a JSON array and nothing else: no introduction, no explanation and no Markdown code fences. Every element of the array is a JSON object with exactly these keys, spelled exactly as written and in this order: columns Every value is plain text or a number - never an object or a list, and never left empty. Do not include the same item twice.

OpenAIAsk OpenAI: prompt. Save it as answer.Ask OpenAI: prompt. Save it as answer.

Run Python code on reply, columns, items_per_run, and generated_at and save it as parsed.Run Python code on reply, columns, items_per_run, and generated_at and save it as parsed.

Set rows to parsed.rows.Set rows to parsed.rows.

If rows is emptyIf rows is empty

Yes

Stop and report a problem: No rows were added. parsed.problem.Stop and report a problem: No rows were added. parsed.problem.

No steps

Set rowsAdded to 0.Set rowsAdded to 0.

For each row in rows:For each row in rows:

If a step below fails, save the error as sheetErrorIf a step below fails, save the error as sheetError

Try

Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.

Add 1 to rowsAdded.Add 1 to rowsAdded.

On error

Stop and report a problem: Added rowsAdded of the length of rows row(s) to '@sheetName' before Google Sheets refused one. The remaining items from this batch were not added; once the sheet or its link is fixed, the next run adds a fresh batch. Google Sheets said: sheetError.message.Stop and report a problem: Added rowsAdded of the length of rows row(s) to '@sheetName' before Google Sheets refused one. The remaining items from this batch were not added; once the sheet or its link is fixed, the next run adds a fresh batch. Google Sheets said: sheetError.message.

Show in the output: Added rowsAdded row(s) to '@sheetName'.Show in the output: Added rowsAdded row(s) to '@sheetName'.

If parsed.note isn't emptyIf parsed.note isn't empty

Yes

Show in the output: parsed.note.Show in the output: parsed.note.

No steps