Hey all, Trying to capture and filter Google Spreadsheet
I saw a lot of tutorials for Airtable that cost money for my clients and I prefer the old ways like Google Sheets, so 2 questions:
1. How can I capture and filter data from Sheets Get API call by two parameters, e.g., phone number and client name?
2. I must use Make Webhooks, or is it possible to direct to Google API?, because first I need to search if the data exists, and after, the user needs to decide if to create a new row or update the matched row.
1. How can I capture and filter data from Sheets Get API call by two parameters, e.g., phone number and client name?
2. I must use Make Webhooks, or is it possible to direct to Google API?, because first I need to search if the data exists, and after, the user needs to decide if to create a new row or update the matched row.
