Hey Zapier team! I wonder if you can help me figure this out somehow. Or if someone else had a similar struggle and found a good alternative.
I have a spreadsheet that feeds data from Google Sheets to Pipedrive. The zap itself is straightforwad:
Trigger - New or Updated row on Google Sheets
Action - Find deal in Pipedrive (option ticked to create a new deal if none has been found)
Action - Update deal based on the previous step
Now, I think this works fine although I haven’t tested it yet. But a major concern came to me when I talked with a colleague that updates the spreadsheet and she told me that she needs to delete all the data on the spreadsheet and replace with new one every day.
We have 14000 rows with the products that we sell, and she needs to export them from our Platform (currently there’s no good way of exporting from it without it being manually) to our Google Sheets, and updates around 200 to 300 of them let’s say.
Would that mean that if she deletes everything and then adds everything back including the 200-300 updated ones, that Zapier would run for all of the rows? Because that would immediately kill my monthly task limits.
If nothing is possible here, is there a workaround that could be done instead?
Thank you so much in advance!
