Skip to main content

 

Hi everyone. 

I created a Zap with the following structure: 
1) every week the trigger is activiated
2) formatter is used to create a “previous week” -7 days
3) parsing data from Apify as CSV
4) formatter is used to split CSV into separate columns
5) save 3 columns (stars, comment and date) in an existing Google Sheets file
6) chatgpt is used to classify the data from column “comment” 
7) add this classification to another column “category” of the existing Google Sheets file for each newly created raw.

The problem is that I do not get the classification generated by ChatGPT for each batch of newly added raws but only for the last of them. I do not understand the logic how Zapier is going to add it to all newly raws if I refer to only 1 single Raw ID…

Would be glad to get help from you.

 

Step 5
 
Data in Google Sheets

 

Hi there @Affication,

Welcome to the Community! 🎉

Before we dig deeper into this, have you tried using the Looping by Zapier app to see if it’ll fit your workflow? You can learn more about the Looping by Zapier app here: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

I'll be keeping an eye out for your response!