what's the best way to do a get api call to check ...
# support
h
what's the best way to do a get api call to check inventory from a google sheet using make.com? Should I use an api request tool? or a custom tool? or the google sheets integration?
v
To clarify your needs: Are you looking to check inventory by reading data from Google Sheets (i.e., perform a GET/read operation), or do you also want to update/add inventory data? This will help determine whether you should use an API Request tool, a custom tool, or another integration method. Sources: - [Google Sheets Integration Documentation](https://docs.vapi.ai/tools/google-sheets) - [Workflows API Request Node](https://docs.vapi.ai/workflows/nodes/api-request)
h
@Vapi Support Bot just read and get it
v
Use Make.com's Google Sheets "Search Rows" module to read inventory data: 1. In Make.com, add a Google Sheets module and select Search Rows. 2. Configure it with your spreadsheet and sheet name, and set a filter (e.g.,
Item = "Widget123"
). 3. The output will return the matching inventory row(s). Example filter setup:
Copy code
{
  "Item": "Widget123"
}
This lets you retrieve inventory details directly from your Google Sheet in an automated scenario. Source: - [Google Sheets Integration Documentation](https://docs.vapi.ai/tools/google-sheets)
h
@Vapi Support Bot but should I use a custom tool or api request tool in the vapi bot?
v
Use the API Request tool in your Vapi bot to call a Make.com webhook that reads inventory from Google Sheets. Set up a Make.com scenario that searches your sheet and returns the inventory data, then use the API Request tool in Vapi to call the webhook URL. Example API Request tool setup:
Copy code
json
{
  "method": "GET",
  "url": "https://hook.make.com/your-scenario-id",
  "headers": {},
  "params": { "item": "Widget123" }
}
This lets your Vapi bot retrieve inventory details on demand. Source: - [Google Sheets Integration Documentation](https://docs.vapi.ai/tools/google-sheets)
h
@Vapi Support Bot tell me the pros and cons of using either
v
Use the API Request tool for this scenario: It's the simplest way to connect your Vapi bot to a Make.com webhook that reads inventory from Google Sheets—no extra setup required. Just configure the tool like this:
Copy code
json
{
  "method": "GET",
  "url": "https://hook.make.com/your-scenario-id",
  "params": { "item": "Widget123" }
}
This approach is quick, easy to maintain, and doesn't require building a custom integration. [See more in the Google Sheets Integration Documentation.](https://docs.vapi.ai/tools/google-sheets) Source: - [Google Sheets Integration Documentation](https://docs.vapi.ai/tools/google-sheets)
t
Hey @Haaris-Blackframe whichever one you want to use is fine, I built a system with both so yes. By the way, how's it going now?
3 Views