I have two google sheets that I query.
One is a reference list of venue data with about 1000 rows.
The other is a list team schedules with about 25 rows.
I loop through the team schedules and use the metadata to scrape a website and.
The return data includes the id of a venue.
I originally had the venue google sheet in the loop, but I was getting “Quota exceeded” errors,
My thought was to move the venue google sheet out of the loop so I only had to query it once, however I cannot figure out how to merge the venue data into the team schedule loop.
what if you load the venue data once before the loop, then loop through team schedules and scrape and finally after scraping use either a Merge or Code to attach matching venue details based on the venue id or whatever identifier you have.
Thank you, that put me on the right track.
I added the spreadsheet node to the start of the spreadsheet (bit of messing around to limit the output, and then added a code node in my loop to create a copy of the spreadsheet output I could use in a merge node.
