What are you trying to achieve?
Upload a file to a google sheet, and enrich it with content from another file I had previously uploaded
Steps taken so far
I’m new to Make, and I’m looking to build an automation, where I upload a google sheet (FileA - up to 100k records) to a google drive, and for each row, it will check if the record already exists in another google sheet I had previously uploaded (FileB - up to 1M records), and update FileA with content from fileB.
I have attempted to do this by using 2 search modules (1 for each file) followed by an update. It’s working, but it’s doing an iteration row by row, which is taking hours to complete. I have attached a print of the scenario I’ve created.
Happy to hear any suggestions on how this could be achieved more efficiently.
PS - There’s also the potential for FileB to be a table in snowflake instead of a google sheet, if that’s more efficient
