How to Schedule Email Reports of your Airtable Data

Mar 30, 2023Rosie Threlfall

In this simple tutorial, we'll run through the steps required to schedule email reports for your Airtable data. We'll be using the Charts & Reports Airtable extension, which can be used to create powerful charts & graphs from Airtable data. These can be exported as PDFs or PNGs and also incorporated into daily or weekly email reports.

Create an Exchange Rates Table

For this example, we will use exchange rate data to create email reports from Airtable. You can copy the data from this Airtable by clicking 'Copy base'. Or use your own data if you would prefer.

Install Charts & Reports

From the extensions menu in Airtable, add the Charts & Reports extension via the Airtable marketplace.

schedule-reports-airtable.jpg

Once Charts & Reports has been installed, click on '+ Add chart' to create a new chart.

schedule-reports-airtable3.jpg

We're going to create two line charts, the first using the following fields: X-axis: Date Y-axis: BRL/USD.

schedule-reports-airtable4.jpg

Create a 2nd line chart and use these fields: ⁠X-axis: Date
⁠Y-axis: EUR/USD & GBP/USD

schedule-reports-airtable5.jpg

You will now see two line graphs like this:

schedule-reports-airtable7.jpg

Schedule Email Reports of Airtable Data

Next, you'll need to upgrade Charts & Reports, as scheduling email reports of Airtable data is a paid feature. Click on 'Upgrade' in the top left of the screen then again on the modal that pops up.

Upgrading Charts & Reports also gives you access to adding unlimited charts and reports as well as downloading PDFs and PNGs. You can also take advantage of the 7-day free trial.

schedule-reports-airtable6.jpg

Once you have upgraded, click on the 'Schedule email' button at the top of the screen.

schedule-reports-airtable8.jpg

For your first time setting up an email report, you'll need to authorize Charts & Reports to read your Airtable data. Click ' +Authorize'.

schedule-reports-airtable9.jpg

On the next tab, you can either choose which base you want Charts & Reports to access. You can also select 'All current and future bases in all current and future workspaces' which means you won't have to authorize bases in the future. Click 'Grant Access'.

schedule-reports-airtable10.jpg

On the next window, enter the email address or addresses you would like the Airtable email report to be sent to. This could be your clients, other team members or just to yourself.

You can set intervals of days, weeks or months and you can also schedule the email to send at a particular time of day for any time zone.

Click 'Done'.

schedule-reports-airtable11.jpg

Your Airtable email report will now arrive in your specified inbox(es) on your chosen schedule.

schedule-reports-airtable12.jpg

Related Posts

How to Add Multiple Y-Axis Series to a Chart in Airtable

How to Add Multiple Y-Axis Series to a Chart in Airtable

Apr 25, 2023

Rosie Threlfall

Airtable Charts
How to Track your Social Media Advertising in Airtable

How to Track your Social Media Advertising in Airtable

Apr 24, 2023

Rosie Threlfall

Facebook AdsAirtable Charts
How to Track your Website's SEO Performance in Airtable

How to Track your Website's SEO Performance in Airtable

Feb 27, 2023

Andy Cloke

Google Search ConsoleAirtable Charts