Need to pull in data from Airtable to automate some reports? With this extension, you can automate exporting CSVs for Airtable Views! This extension can be scheduled to run regularly, and supports webhooks. It provides you with a static URL for each CSV. Every time the extension is re-run, the URL would reflect the latest CSV with the latest data.
Example
This CSV was exported with the extension for this Airtable View. To download the CSV, right click on it, and then click “Download Linked File”.
Features
- Supports multiple views from up to 10 different tables/bases.
- Ability to schedule files to be exported regularly.
- Unchanging URL for CSV files even when exported again.
- Ability to trigger export function by a Webhook.
- Supports exporting Markdown to retain formatting for the new rich text field.
Troubleshooting
Some fields contain random characters, why?
These are linked fields showing record IDs. To solve this, add a lookup field and use it instead. We recommend to use formulas not just for linked records, even for currency, date formats and many other field types that are not fully supported in Airtable API.
Will exported files include attachments?
Attachment fields will only contain direct links to the files. This is not a limitation in our product. That’s just the nature of CSV file format. It’s designed to store text data in a spreadsheet. It’s not possible to store image files in them. However, if your goal is just to show the images in Excel, then there’re ways to do that.
Some fields are displayed in the wrong format, why?
By default, Airtable API doesn’t show fields in the exact same way they look on Airtable. For example, linked record names will be shown as IDs instead. To fix that you would need to add a lookup field that shows the linked record’s name. We recommend to use formulas for many field types like currency, date and any other field that needs to be formatted.
How to import the exported CSV in Google Sheets?
If you’re trying to import a CSV file in Google Sheets, you can follow the instructions here.
I want to create a new post on WordPress when a field updates. For example, when I’m done creating an outline for a writer, and the client approves that outline, I want to be able to set a start date and have WordPress automatically create a post based on the data that’s available from the outline: title, category, tags, slug, meta description/excerpt, and featured image.
Although, we don’t have an integration with WordPress directly, but you can use our CSV exporter extension to achieve that. You can use the generated CSV URL to create new posts using some WordPress plugins.