Skip to main content
Question

How do I set up a daily Zapier schedule to process individual rows from a spreadsheet and email responses to clients?

  • December 8, 2024
  • 3 replies
  • 36 views

I am trying to create a zap where first step is scheduler by zapier at 4 pm daily has to start get information from  spreadsheet send to chat gpt  where i map each column on that row map in chat gpt and next step is the response emailed to client and return to next row for same cycle with next row. the problem i am having from spreadsheet it takes all rows together no matter how i set up actions in spreadsheet second problem i do not know how to make zapier make repeated steps untill no rows left with information. 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • December 9, 2024

Hi ​@renatnyc,

 

Welcome to the Community.

 

Zapier doesn't support looping actions to process each spreadsheet row automatically. Use the "New Spreadsheet Row" trigger to activate your Zap for each new row as a workaround. Set up actions like sending data to ChatGPT and emailing responses for each row, and add new rows to the spreadsheet daily to trigger the sequence.

 

I hope this helps. If you have further questions or need more clarification, please feel free to ask.


  • Author
  • Beginner
  • December 10, 2024

thank you so much for your great input. It did fix problem with showing all values in one on output when mapping but the questions still is how make zapier to run on second line after it finished with one line? I see on output one line but not second and it runned and stopped did not move to take values from second row.


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • December 10, 2024

Hi ​@renatnyc,

You might need to utilize Looping by Zapier for your desired workflow. Looping is a tool you can use to run an action or set of actions more than once.

You can learn more about Looping by Zapier here: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

Hopefully, this helps.