Integrate Crontap Schedules with Airtable through Make for Automated Tasks ✨

Make.com allows integrating Crontap schedules with Airtable. This can be used for data collection, data processing, and data visualization or anything in between!

Primer on webhooks

Crontap is capable of integrating with various services via webhooks.

Webhooks are the digital messengers that deliver real-time updates and data between applications, enabling seamless integration and automation. With webhooks, you can streamline processes, trigger custom actions, and revolutionize the way applications communicate and collaborate.

Still curios? Check out this in-depth article on webhooks.

Preparing Airtable

Sign in to airtable.com and create a new base. Let's call it SpaceFlight News so we can easily identify it later.

Delete all existing rows & fields in the table and create the following fields:

• id - number
• title - single line text
• summary - long text
• url - URL

This configuration is needed for the example we'll be using in this tutorial. Feel free to use your own configuration depending on what URL/API you've chosen to use in the Crontap schedule.

Let's head over to Make.com to connect with Airtable. Keep this tab open as we'll be coming back to it later to check if data is being sent to Airtable.

Setting things up in Make.com

Sign in to the make.com platform and go to Scenarios.

1. Press the Add button (big plus in the middle) and select Webhook.

   • Then select Custom Webhook.

2. Press Create a webhook.

   • Give your webhook a name and press Save.

3. You should now see a Webhook URL. Copy this URL and let's jump over to Crontap. Keep this page open, we'll come back to it later.

It should look something like this:

Setting up with a schedule in Crontap

Create a schedule or edit an existing one.

On the schedule editing page, scroll down to the last section called Integrations.

1. Press the Add Integration button.
   • Paste the URL you copied from make.com into the Webhook URL field.
2. Optionally, you can
   • Include URL: on the url of the schedule will be sent to make.com so you can display it in the notification etc. This is off by default in case the URL is sensitive.
   • Call on success: on if you want to send a notification when the schedule succeeds.
     Keep in mind if you turn this on and have frequent schedules, you might hit the limit of make.com's free plan.
3. Press Save integrations.

Now all that's left is to test it out!

• Press Update/Create to save your settings
• Press Perform test to test it out.

If the schedule ran OK, you should see the button change to Test OK.

That's all that is needed in Crontap!

Let's head over to make.com to link it with Airtable

Integrating Airtable on Make

Now let's get back to the Make.com scenario we created earlier. Hope you still have the tab open!

Regardless if the schedule actually failed or succeeded, you should now see that make.com received the request.

1. press on the Add another module "plus" button.

2. search for Airtable and select it.
3. then select Create a Record.
   • you will now be asked to create a connection to Airtable.

4. press Create connection

   • the connection type should be Airtable OAuth.

   • give the connection a name, e.g. SpaceFlight News.

   • press Save, then

   • press Add a base

     • select the base you created earlier - e.g. SpaceFlight News.

   • authorize by pressing Grant access

     

     

5. you should be redirected back to Make. Let's select the base and table we want to send data to.

   • Select the base - e.g. SpaceFlight News.
   • Select the table - e.g. Table 1.

6. let's configure data that goes into the table.

   • match each table field with the data you want to send from Crontap, like shown below

   

   📝 All response data received by Crontap will be available under data. Open it up to verify all data you expect is there.

7. press OK.

8. finally, turn on Scheduling on the bottom left and

9. press the Save button on the bottom action sheet to save.

That's it! Next time the schedule runs, you should get a new entry in your Airtable table. 🎉

Final notes

To keep this tutorial simple, we didn't go into detail on how to handle:

• a Crontap schedule that returns e.g. a list of articles.

  That is possible by using a loop or router in make.com

• how to handle a failure in one of the schedules

  That is possible by using a router in make.com

• how to ensure that there are no duplicate entries in Airtable

  That is possible by using **Upsert a record** instead of **Create a record** when setting up the Airtable integration in make.com

We'll dive into each of those topics in future guides.