Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Asked & Answered Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

downloading a csv doc from an email link and sending the attachment to airtable

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?

Best answer by adamsmartschan

@TowPiglet -

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.

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

adamsmartschan
Forum|alt.badge.img+6

@TowPiglet -

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.

  • TowPigletBeginner
  • Author
  • Beginner
  • July 6, 2020

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

 

 

 

adamsmartschan
Forum|alt.badge.img+6

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.

    Early access


    Next Gen Zaps

    Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.

    Request access now


    Terms & ConditionsAccessibility statement