Automation Workflow Request: Tawk.to Chat Integration with Google Maps and Google Sheets

Community Discussion
1

I want to set up an automation system that performs the following tasks:

  1. Initial Interaction: Start the process when a user initiates a chat on Tawk.to.
  2. Data Collection: The user provides pickup and drop-off locations via chat, and requests a price estimate.
  3. Data Parsing: The information from the chat is sent to a parser to extract the relevant details.
  4. Distance Calculation: The extracted locations are sent to Google Maps Distance Matrix API to calculate the distance.
  5. Pricing Calculation: The distance data is then sent to Google Sheets, where dynamic pricing is set up based on the distance. Google Sheets calculates the price for each vehicle using this pricing structure and updates the total price.
  6. Response to User: The calculated total price is sent back to the Tawk.to chat as a response.

I need to achieve this automation on Make.com. I’ve been informed that using REST API is not an option. What alternative methods can I use to implement this workflow?