Search for rows in google sheets before adding new row

Hi,

New user to make though have some experience of Python, I am however in no way a coder or automation expert. Zapier is as advanced as I get.

I have a scenario setup where using oauth2.0 data is taken from a system and the relevant columns are moved into google sheets.

It currently gets the last 200 records. I am really struggling to make it not put another 200 in and only parse data that isn’t already there.

I’ve tried adding another google sheets step to search the records (after http and before the iterator) then route where records not found to go to sheets - but it doesn’t work.

Happy to answer any questions, and apologies for eh naivety - we’re all here to learn though!

Thanks

Welcome to the Make community!

1. Screenshots of module fields and filters

Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

Following these steps will allow others to assist you here. Thanks!

1 Like