exotic-emerald•2y ago
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.
2 Replies
To capture and filter data from Google Sheets using a GET API call, you can use the Google Sheets API. However, it's important to note that the Google Sheets API doesn't directly support filtering by multiple parameters like phone number and client name. You would need to retrieve the entire data set and then filter it within your Voiceflow project.
Here's a step-by-step guide on how to do this:
1. First, you need to set up your Google Sheets API. You can follow the instructions provided by Google in their API documentation.
2. Once you have your API set up, you can add an API block to your Voiceflow project. In the API block, select GET as your request type.
3. For the endpoint, you would use the URL provided by the Google Sheets API. This URL will point to the specific Google Sheet you want to access.
4. In the Headers section, you would typically need to include your API key for authorization. This will be provided when you set up your Google Sheets API.
5. After setting up the API block, you can send a request to retrieve your data. If the request is successful, you will receive a JSON object containing your Google Sheets data.
6. To filter the data by phone number and client name, you would need to use a combination of IF and SET blocks in Voiceflow. You would use the IF block to check if the phone number and client name match your desired parameters, and if they do, you would use the SET block to save this data to a variable.
As for your second question, you can indeed use Google's API directly without needing to use webhooks. However, to create a new row or update an existing row, you would need to use a POST or PUT request, respectively. This would require additional API blocks in your Voiceflow project.
Remember, when working with APIs, always refer to the API documentation for specific details on how to structure your requests and what data you can access.
exotic-emeraldOP•2y ago
I don't know the desire parameters it can be {last_utterance}
Can you be more specific about defining parameters in google spreadsheets and finding them process
This is address https://gsx2json.voiceflow.studio/api belong to voiceflow?