Airtable Pagination

This code will let you pull all of the data out of one view in one of your Airtable bases. It's set up to handle pagination on Airtable's API and also grabs all of the fields available without you needing to specify each column name.

NOTE: In order for this script to pull all of the fields properly, your data set must have all of the fields populated since Airtable will omit a column if it's null.

To customize the script to your own needs, update the variables within the scriptSettings() function.

To run the script, execute the importAirtableData() function.

• You can set up a Time-Driven trigger to run the importAirtableData() function on a schedule so that you data is always in sync with your Airtable.