Need to pull in data from Airtable to automate some reports? With this automation, you can automate exporting CSVs for Airtable. This automation can be scheduled to run regularly and supports webhooks. It provides you with a static URL for each CSV. Every time the automation is re-run, the URL would reflect the latest CSV with the latest data.
Example
This CSV was exported with the automation 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.
- 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 rich text field.
💡Attachments
If you need to download Airtable attachments, you can use this automation.
Use Cases
- Automatic backups
- Pair it with a scheduled email
- Use
IMPORTDATA(url)
function in Google Sheets - Sync WordPress posts via WP All Import
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 using 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 of our product. That’s just the nature of the CSV file format. It’s designed to store text data in a spreadsheet. It’s not possible to store image files in them.
Some fields are displayed in the wrong format, why?
By default, Airtable API doesn’t show fields in the 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 using 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.