With Scoop, you can capture your Airtable data and blend it with other sources. In addition, you can run sophisticated calculations in your Scoop dataset using powerful spreadsheet logic and even save that data back into Airtable.

Connecting to Airtable

To connect to Airtable as a datasource, create a new dataset linked to Airtable. First, on the datasets page, select applications as a source:

Next, select Airtable:

Select whether you are selecting an object that you want to snapshot daily, or an object which is transactional (e.g. an activities object).

Next click on the link to take you to Airtable where you can login and then choose which Bases you would like to utilize with Scoop and then click "Grant Access".

After that, return to the Scoop window and select the Base for this dataset.

Select the table you would like to leverage and the fields you would like to bring into Scoop.

Also, specify a dataset name and then click "Create Data Source" to create a Scoop dataset from this table.