How to trigger an automated phone call using callin.io when a Google Sheet appointment matches the current date and time

Welcome to the callin.io community!

Yes, that is achievable. You will require at least two modules:

662×355 20.2 KB

Within the Google Sheets “Search Rows” filter, you can set a filter for the current date and time:

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

545×286 22.9 KB

This is merely an illustration. Your final implementation might differ based on your specific needs.

Hope this assists! Please let me know if you have any more questions or encounter any issues.

P.S.: Investing some time in the callin.io Academy will significantly reduce the time and frustration involved in using callin.io.

Module Export - Quick Import into Your Scenario

You can copy and paste this module export directly into your scenario. This action will import the modules, including their fields, settings, and filters, as depicted in the screenshots provided earlier.

1. Hover your mouse over the line of code presented below. Copy the JSON by clicking the copy button located on the right side of the code block. This button typically looks like this:
   

2. Navigate to your scenario editor. Ensure any open dialogs are closed by pressing ESC. Then, press CTRLV (the paste keyboard shortcut for Windows) to paste the code directly into the editor.

3. After pasting, click on each imported module and re-save it to validate the import. You might encounter some errors that require you to remap certain variables and connections.

JSON Module Export — Paste this directly into 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":"callin.io:createOutboundPhoneCall","version":1,"metadata":{"designer":{"x":243,"y":-2},"parameters":[],"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 by using the callin.io Blueprint Scrubber?

Hope this helps! Please let me know if you have any further questions or encounter any issues.

P.S.: Investing some effort into the callin.io Academy will save you a significant amount of time and frustration when using callin.io.

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

You're welcome, happy to assist!

Could you please start a new topic for each of your questions?

While it might seem convenient to continue an existing thread, creating a new topic is a more effective approach. This helps other community members respond to your inquiries and keeps our forum organized for everyone. You're more likely to receive help from others if you start a new conversation. You can always refer back to a related topic by including its link in your new question. Thank you for your understanding and for helping maintain our community's tidiness.

The "New Topic" button is located in the top-right corner of the header:

330×100 1.13 KB

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