Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to populate a Google Sheet with AI-generated book ideas from Zapier

  • March 15, 2026
  • 3 replies
  • 14 views
T

Hi guys, new to this forum and noob on Zapier.. just starting using it.

I am frustrated by a simple zap and I would really appreciate your help.

Step 1, an AI by Zapier (Open AI) generates 10 ideas of books, with 3 fields (title, sales volume, date). 

Step 2, I just would like a Google sheet to be populated with these 10 ideas (10 rows with 3 columns). As easy as that. Despite 100 attempts, I can’t do it. The sheet is empty and Copilot fails to fix.

Maybe I fail to understand how to prompt and whether step1 needs to generate an array or not (true/false?)

Any guidance please?

Pardon me if I choos the wrong forum seciont to post

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • March 15, 2026

Hi ​@Tommy78 

AI by Zapier can’t be used as the Zap trigger step, so clarify how your Zap steps are outlined and configured by sharing screenshots to give context.

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor
T
  • Tommy78
  • Author
  • New
  • March 15, 2026

Hi thanks for your reply.

Actually, the first step is an “on schedule” trigger which every morning at 7AM demands an action to an AI by Zapier (step 2).

This step 2 prompt requires the AI to generate 10 ideas of books, including titles, sales potental (units per year) and date. Pretty simple and it’s working fine. I’ve tested and seen the outputs.

The problem is now. How can I populate a Google sheet with those 10 ideas (title, sales, date). I want these ideas to be 10 rows in a sheet. No rocket science, but I don’t find a way.

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • March 16, 2026

​@Tommy78 

Make sure the data returned from AI by Zapier is an array of objects.

Configured under Advanced Options > Return as array of objects

(see screenshot below)

 

Add this Zap action: GSheets - Create Multiple Spreadsheet Rows

 

 

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor
Terms & ConditionsAccessibility statement