Airtable in Sync with DronaHQ Studio Sheets using Zapier

This article will show you how to keep tables in Airtable bases in sync with DHQ Sheets.

Prerequisite - You should have configured Zapier with DronaHQ Studio account. If not then refer Configuring Zapier

In this example, consider a use case, where you will be using Airtable bases for your daily needs but at the same time you want those details to be added in DronaHQ Sheets.

Basically we will have a Create a Zap with Airtable as a Trigger and DronaHQ as Action. Below are the steps that you can follow to achieve the same -

  1. Login into Zapier

  2. Click on Make a Zap option

  3. Under Choose App & Event option, search and select “Airtable” option

  4. Select Trigger as - “New Record”

  1. Under Choose Account , Select/Add your Airtable Account which has the table which you want to sync.

  2. Select the Base and Table which you want to Sync with DronaHQ Sheet as shown below.

  1. You can either select " Test & Review " or " Test & Continue " or " Skip Test ". Select " Test & Continue ".

  2. Airtable - New Record Trigger is configured successfully. Now, we need to connect this Google Sheet with DronaHQ Studio’s Sheet. Select the DronaHQ app and Select “Create New Sheet Row” as an action as shown below and click on Continue.

  1. You can add an existing DronaHQ Account or Add a DronaHQ Account using the API key which has the DronaHQ Sheet to be in sync. You can find API Key under DronaHQ Studio Login -> Settings -> Integration -> API Key. Click on Continue.
    For more information, you can refer Using DronaHQ in Zapier

  2. Select Sheet Name and Configure all the Columns of that sheet that will be synced. Add your DronaHQ Studio Email Id. This is the email that will appear under Created By Column in Sheets when Row is created using this Zap.

Now, to connect the Airtable Bases Table’s column to DHQ Studio Sheet, click on the + icon on the right side of Textbox and select the corresponding option from the dropdown as shown below.

Once, all columns are configured as shown below, Click Continue**.

  1. You can either select " Test & Review " or " Test & Continue " or " Skip Test ". Select " Test & Continue ".

  2. Click on Done Editing and Click on " TURN ZAP ON" Once the ZAP is ON, whenever a new Row is added in Above Airtable Base’s Table, a corresponding new row will be created in DHQ Studio Sheet.

Important Points to Note -

  1. For Existing Data, you can either Copy all the Data using CTRL+C (Windows) / CMD+C (Mac) and Paste is into DronaHQ Sheet using CTRL+V (Windows) / CMD+V (Mac) OR you can donwload a CSV and in DronahQ Studio create a new Sheet and import this CSV.

  2. Zapier polls Airtable data every 15 minutes, so there will be a max delay of 15 minutes for new row changes to be reflected in DHQ Studio Sheet.

  3. In above example, we used DronaHQ New Sheet Row action. For other actions, like update/delete or other automated action, you can select Initiate a Workflow option based on your need.

  4. Likewise, instead of Airtable, you can use any other 3rd party service and connect it with DronaHQ Studio using Zapier.

  5. Existing Rows in Airtable’s Table will not be triggered. Only new Rows added post creating this Zap will be triggered and available to DHQ Sheet.