Airtable

What is Sheet Director?

Sheet Director is a G Suite add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho,PayPal etc.

It is available in the G Suite Marketplace and Chrome Web Store. Please check Installation instructions to install the add-on.

What is Airtable?

Airtable is the all-in-one collaboration platform empowering companies. Realtime Collaboration. Easy As A Spreadsheet. Drag & Drop File Uploads. Calendar Views. 200+ Templates. 350+ App Integrations. Spreadsheet Interface.

Use Case(s)

> Pull all data from Airtable objects and store it into a spreadsheet.

Airtable

Sheet Director

Google Sheets

Setting up Airtable in Sheet Director

Choose App and Service:

Select Airtable from the list of applications.
Select service as Query.
Switch on Run Automatically if the queries needs to be executed in regular intervals.

Trello Configuration

Provide your API Key
Enter the Table Url
Click on connect to Airtable to connect to Airtable so that you can pull data.

API Key

Airtable uses Api-key authorization to connect to your account.

To Generate Api-Key

Go to https://airtable.com/account
Click on "Generate Api key"

Table Url

Table Url is required to connect to your table

To Get Table Url

Go to https://airtable.com/api

Under your table name you will find a url similar to "https://api.airtable.com/v0/app7XbFxcBQRKZe7O/tablename", copy the url and put it in the Table url text box

If Airtable is connected successfully the following screen appears.
Select the maximum result that is required.
Select the destination sheet to save the data or create a new sheet by clicking the Add new icon.