Everyday I get an email with a link to a report of how much my trucking company spent on fuel. I download that CSV doc to my computer and then drag and drop it into a CSV block in Airtable and all the transactions get added. How can I automate the downloading the document and adding it to Airtable?
Page 1 / 1
You should be able to accomplish this with Formatter and Airtable’s Create Record action. I haven’t used line items in Airtable recently, but if they’re not supported, you can likely get around it by using a Google Sheet in between.
Here’s what I did and the error I got
Gmail - New email matching search
Formatter Text - Find the url
Formatter Utilities - Import CSV
Error
The utilities could not be sent to Formatter by Zapier.
The app returned "Could not determine delimiter" It’s a wired link, here is the email I get everyday Job: 'Fleet One Report -Zapier CSV' completed.Download at: https://emgr.efsllc.com/cards/CardsJob.action?getJobFile&fileId=e80f1b8b-7f1a-4618-8269-3d7bfe37b30e.1593933050001.jobdata
Please do not reply to this email. If you have questions or concerns, please contact your account manager. Let me know what I’m doing wrong
Here’s the documentation on that error:
“Error: Could not determine delimiter
The CSV file you're trying to import doesn't use a recognized delimiter (commas, semi-colons, tabs), or the delimiter was not able to be recognized. If you know your delimiter or you have a One Column CSV, you can select that in the Type of CSV File option.”
Try Comma Delimited first – that’s the most common.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.