Scraping data into Airtable

With Simplescraper you can scrape data from any website directly into your Airtable bases quicky and easily. This guide shows you how.

Follow the steps below or watch the short video above

  • In Simplescraper navigate to the Integrate tab and you'll find the Airtable integration. Toggle the Activate switch to enable the integration. There are four sections to be completed: API key, Base ID, Table name and Included properties
  • To add your API key navigate to your Airtable account page and under the API section you will find your API key. Click on the key, copy it and then paste it into the API field in Simplescraper. Press enter to save
  • To add your base ID navigate to the Airtable API page and click on the base that you wish to scrape data into. When the page loads you'll find a string in the URL that begins with 'app', for example 'appQjzhfyaBCde'. Alternatively this string can be found in the introduction section in green font. Copy this base ID and paste it into the Base ID field in Simplescraper and press enter to save
  • To add your table name, in Airtable navigate to the base you wish to scrape data into and note which table you want the data to appear in. Copy this table name then paste it into the Table name field in Simplescraper and press enter to save
  • To choose which properties of your data to scrape into Airtable, toggle the name of that property in the Included properties section. For each property that you choose to include, a single-line text field with the exact same name must exist in the table you're scraping data into. So add a field in Airtable for each property that you choose to include before continuing.
  • Copying links: If the property that you wish to include is a link create an additional field for the link with '_link' appended to the name. For example if you have a property called 'jobtitle' that returns a link then create both a 'jobtitle' field and a 'jobtitle_link' field in Airtable
  • Click 'test integration' to verify that Simplescraper can successfully connect to Airtable. If everything is correct you will see a 'test passed - successfully connected' message
  • Now you're ready to run your scrape recipe. Click run recipe and when the task completes your data will instantly and automatically be saved to your Airtable base

Troubleshooting

If the test integration button didn't return a 'test passed' message it's likely an issue with your Airtable configuration. Follow the steps below for solutions to common error messages:

  • 'Please toggle the Activate switch to on': you need to activate the Airtable integration. The toggle is at the top of the Airtable integration section and is green when toggled on
  • 'Please add Airtable API key': you have not added or saved the API key. Please follow the steps above
  • 'API key may be incorrect': ensure that you copied the API key correctly. It should begin with 'key'
  • 'Please add Airtable Table name': you have not added or saved the Table name. Follow the steps above
  • 'Base ID or table name may be incorrect or may not exist': verify that the base ID matches the base that you wish to scrape data into, and ensure that a table with the exact same name that you entered in the 'Table name' section exists in that base
  • 'One or more fields was not found in Airtable': verify that each property that you chose to include has a matching single line text field in Airtable. If this does not resolve the issue, un-toggle all properties and then toggle them on one by one, clicking 'test integration' each time to help identify the field that is causing the issue

Note: your Airtable API key is encrypted before being securely stored. If you have any questions please reach out to us via chat.