Akkio Docs
  • Akkio Documentation
    • Akkio FAQ
  • Account and Settings
    • Team Settings
    • Organization Settings
    • Account Settings
    • Role Based Access Control
  • Demo Models
    • Demo Models
      • Lead Scoring
      • Retail Sales Forecasting
      • Predict Credit Card Fraud
      • Identify Customer Churn
  • Setting up Integrations
    • Connecting Data
    • Airtable (Beta)
    • Google Ads (Beta)
    • Google Analytics 4 (Beta)
    • Google BigQuery
    • Google BigQuery (Service Account)
    • Google Sheets
    • HubSpot (Beta)
    • MariaDB (Beta)
    • MongoDB (Beta)
    • MySQL (Beta)
    • PostgreSQL (Beta)
    • Redshift (Beta)
    • Salesforce
    • Akkio Data Chat for Slack
    • Snowflake (Username / Password) (Beta)
    • Zapier
  • Prepare your Data
    • Prepare
      • Chat Data Prep
      • Clean
      • Merge & Fuzzy Merge
      • Table View
      • Pivot View
      • Deploying Chat Data Prep
  • Explore
    • Chat Explore
    • Chart Types
  • Building a Model
    • Predict
      • Insights Report - Classification
      • Insights Report - Regression
    • Forecasting
      • Insights Report - Forecasting
    • Model Types
  • Deploying a Model
    • Deploy
      • Google BigQuery
      • Google Sheets
      • HubSpot (Beta)
      • PostgreSQL (Beta)
      • Salesforce
      • Snowflake (Beta)
      • Web App
      • Zapier
  • REPORTING AND SHARING
    • Reports
    • Dashboards
  • REST API
    • API Introduction
      • Quickstart
    • API Options
      • cURL Commands
      • Python Library
      • Node.js Library
    • API FAQ
  • Rest API (v2)
    • Documentation
Powered by GitBook
On this page
  • Overview
  • Importing Data

Was this helpful?

  1. Setting up Integrations

Airtable (Beta)

How to set up Airtable Imports

PreviousConnecting DataNextGoogle Ads (Beta)

Last updated 10 months ago

Was this helpful?

Airtable support is currently in beta. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.


Overview

Our Airtable integration allows you to:

  • Import your data, allowing you to clean and transform your data as well as ask it questions via Chat Explore.

You must allow network traffic from the public IP address 54.197.189.139 in order to allow Akkio to access your data.

Importing Data

To import data, first create a new project.

Select the Airtable button.

Click "Connect Dataset" to add a new dataset.

Enter connection details for your database.

We need these fields to pull your data in:

Fill this information out then hit the "Continue" button. Next you will be prompted to enter the Base and Table names.

Fill this information in and hit "Continue." We will then validate the connection.

If we're successful, you'll move forward to the data loading screen, where your data is syncing behind the scenes.

You may need to wait for a little bit for the data to import. Rest assured that we're importing data behind the scenes. Small datasets should only take a few minutes; large datasets may take longer.

Once your data is done importing, you'll see it populate onto the screen.

From here, you can do anything you like to the data - clean and transform it on the Prepare tab, ask Chat Explore questions on the Explore tab, you name it!

Personal Access Token: You can generate one here: . This token must have scopes data.records:read and schema:bases:read as well as Access settings that permit access to whichever table you are trying to import.

https://airtable.com/create/tokens
Create a new flow from the homepage.
What your personal access token permissions should look like.