‍

Dokin is a powerful tool that enables you to seamlessly integrate data from Airtable into Google Sheets. With Dokin, you can easily automate your data reporting and save valuable time. In this tutorial, we'll show you how to use Dokin to integrate Airtable with Google Sheets.

‍

Step 1: Install and Set Up Dokin

To get started, you will need to sign up for Dokin and install the Dokin add-on in your Google Sheets. To do this, make sure you have installed Dokin on your Google Workspace Marketplace. If you need help on this, you can always refer to our guide on how to install Dokin on your Google Workspace marketplace. Once you have installed the add-on, you can launch it and sign up with your Google Workspace account.

‍

Step 2.  Connect your Airtable account to Dokin.

Once you have launched your Dokin add-on in Google Sheets, you can choose the data you want to import. 

‍

Click on Import new data

‍

‍

Then select the source of data you want to import, in this case Airtable:

‍

‍

If this is your first time connecting to Airtable with Dokin, you will be asked to connect your Airtable account to Dokin. To do so, click on “Connect”:

‍

You will then be redirected to an Airtable authorization page, where you need to choose the Airtable base(s) that you want to connect to Dokin. Click on “Add a base” and choose whether you want to connect a specific base or all current and future bases (recommended): 

‍

‍

Once you have made your choice click on “Grant access”:

‍

Congrats! Your HubSpot account is now connected to Dokin. You can now import and sync live data in your Google Sheets with just a click!

‍

Step 3: Start importing data

Once you have connected your Airtable account to Dokin, you can create a new Dokin import. You can:

• Select a base to import
• Select the table you want to import
• Name your import
• Schedule automatic data syncs (optional)

‍

In this example we are connecting the Tasks and timeline table from our project tracker:

‍

‍

We can select whether we want to schedule an automatic refresh of our data on a weekly, daily or hourly manner. In this case we are going to keep it manual: 

‍

‍

We can now click on Import and get the magic started! 

‍

Step 4: Start Syncing Your Data

Once you click on import, Dokin will run the connection and import your Airtable data into your spreadsheet. Your data is now synced! You can manually refresh it by clicking on the refresh icon of your Airtable connection. You can also add a new table or run a new data report by clicking on “Import New Data”.

‍

‍

It’s that easy! With Dokin you analyze and present real-time Airtable data. 

Build insightful reports in seconds, try Dokin!

‍