Hi Zapier Community,

I’m currently experiencing an issue with a Zap I created, and I need some guidance to fix it. Here’s what my Zap is supposed to do:

1. When a new record is created in Airtable,
2. It finds a specific Google Sheets file in Google Drive,
3. Looks up a row in the Google Sheets file based on a Reference #,
4. Updates the record in Airtable with the matching data from Google Sheets,
5. Optionally creates or updates a contact in OpenPhone.

The Zap worked initially, but my master Google Sheets file has grown too large apparently, and now the Zap fails at Step 3 ("Lookup Spreadsheet Row"). The error code is “maximum call stack size exceeded”. I believe this is because the file size and number of rows are overwhelming Zapier.

I’ve brainstormed a few ideas, like splitting the Google Sheets file or optimizing the lookup process, but I’m not sure the best way to proceed. Specifically, I’d like to know:

1. Is there a way to handle large Google Sheets files in Zapier without splitting them? 
2. What are best practices for efficiently looking up rows in a Google Sheets file with 100,000+ rows with 6 columns of data?
3. Is there a way to dynamically reference smaller Google Sheets files split by criteria (e.g., by date or year)?

I’d love to hear your advice or see examples of how others have managed similar workflows!

Thanks in advance for your help!