Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 13, 2021 07:43 PM
Hey guys,
I have a need but I don’t know if it’s possible, I need
save data from an airtable in Excel or CSV and send attachment via email
It is possible?
I appreciate any help or idea.
Jul 14, 2021 05:54 AM
If this is a one-off thing, you could click the ellipsis menu next to the view name and choose “Download CSV”. Save and attach it as desired.
However, my gut says that you want to do this on a regular basis as part of an automated process. This is also doable, but not natively within Airtable. You’d need to use an integration service like Zapier or Integromat to retrieve the data from Airtable, build the CSV (or possibly an Excel file, depending on which service you use), then attach it to an email. I haven’t done this exact process myself, but my gut says that @ScottWorld could walk you through how to do it using Integromat better than I could.
Jul 14, 2021 07:59 AM
Yes, you can easily do this with Zapier or Integromat.
As an Integromat Partner, I much prefer Integromat over Zapier because it is more powerful, easier to use, and much cheaper than Zapier.
They have some CSV great tools built right into Integromat, and of course they have full support for Microsoft Excel, Google Sheets, sending emails, and more:
If you have a budget for this project and you’d like to hire an expert Airtable consultant & Integromat Partner to help you with any of this, please feel free to contact me through my website at ScottWorld.com:
Jul 14, 2021 11:46 AM
Thanks for the answers.
I’m using integromat.
I’m actually now trying to export the Airtable data to Google sheet, and then send this spreadsheet attachment via email.
I don’t know if it’s possible
Jul 14, 2021 02:38 PM
Another option is to use a script that creates the csv or Excel file using the CloudConvert service (or another similar service) and attaches the csv file to a record. Then send the file using Airtable email automations. I have written several scripts with different variations of this scenario for various clients.
(The script cannot create the attachment completely by itself because when uploading an attachment with code, the file must be hosted on a publicly accessible url.)
Since you are already familiar with Integromat, if you already have plenty of Integromat operations available per month, the Integromat option may be more cost effective for you.
However, the scripting option may still be useful in some cases, depending how many and how often you want to create csv files and what your Integromat limits are.
Aug 05, 2024 06:49 AM
hello Kuo, can i have that script you mentioned? My head department needs a specific line to be in excel format so they upload it at the test level... so i have to use the excel + email automation.
also, can i "pre-set" an excel that it can use? (meaning, like a template?
why i ask: since the form gives the items as separate pieces of data (example: your name on one column, and surname in another... while the excel needs to have sometimes, name, and surname in 1 column - NO COMMENT).