How to Trigger a automate phone call using Make.com and VAPI when an appointment date and time stored in Google Sheets matches the current date and time

How To
1

image
image773×218 13.7 KB

2

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of two modules:

662×355 20.2 KB

In the Google Sheets “Search Rows” filter, you can filter by the current date and time:

{{formatDate(now; "DD-MM-YYYY HH:mm")}}

545×286 22.9 KB

This is just an example. Your final solution may or may not look like this depending on your requirements.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

3

Module Export - quick import into your scenario

You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.

  1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:

  2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.

  3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.

JSON module export — paste this directly in your scenario

{"subflows":[{"flow":[{"id":1,"module":"google-sheets:filterRows","version":2,"parameters":{"__IMTCONN__":95013},"mapper":{"from":"drive","valueRenderOption":"FORMATTED_VALUE","dateTimeRenderOption":"FORMATTED_STRING","spreadsheetId":"","sheetId":"Test Sheet","includesHeaders":true,"tableFirstRow":"A1:CZ1","filter":[[{"a":"K","o":"text:equal","b":"{{formatDate(now; \"DD-MM-YYYY HH:mm\")}}"}]],"sortOrder":"asc"},"metadata":{"designer":{"x":0,"y":0},"parameters":[{"name":"__IMTCONN__","type":"account:google","label":"Connection","required":true}]}},{"id":2,"module":"vapi:createOutboundPhoneCall","version":1,"metadata":{"designer":{"x":243,"y":-2,"messages":[{"category":"setup","severity":"error","message":"Value must not be empty."}]}}}]}],"metadata":{"version":1}}

Note: Did you know you can reduce the size of blueprints and module export code like the above, using the Make Blueprint Scrubber?

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

4

Thanks. Can you help me please with this one also 2025-03-02T04:16:00Z

5

No problem, glad I could help!

Could you please create a separate topic for each question?

While it’s tempting to continue an existing thread, a more effective approach would be to start a new topic. It helps other community users to respond to your query, and keeps our space organised for everyone. If you start a new conversation you are also more likely to get help from other users. You can refer others back to a related topic by including that link in your question. Thank you for understanding and keeping our community neat and tidy.

The “New Topic” link can be found in the top-right of the header:

330×100 1.13 KB

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.