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 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

CSV Download into Database

  • January 24, 2020
  • 5 replies
  • 287 views
V

Hi everyone! I'm new to Zapier, but wanted to see if my use case was possible. There's a website that has a CSV file that you can download. It's updated on a monthly basis and the file name or link doesn't change. Each month, I have to manually click on the link, download the CSV and then upload the results to a database. I'd like to be able to automate that process. Is that something Zapier can do?


Best answer by Liz_RobertsBest answer by Liz_Roberts

Hi @Vinnie ,

Circling back to summarize the above suggestions and to make sure you were able to automate this workflow!

 

Solutions summary:

  • Download file (to GoogleDrive/Dropbox) for Zap to access

OR

  • Access via API request (opening up dev tools→ Network → Export CSV/keept inspection tool open while visiting site)  

 

Please let us know if you have any additional questions!

View original
    Did this topic help you find an answer to your question?
    This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

    5 replies

    andywingrave
    Forum|alt.badge.img+9
    • andywingraveZapier Expert
    • Zapier Expert
    • 854 replies
    • January 25, 2020

    Hey there! Welcome to the community!

    What you're trying to do is certainly possible, but it may depend on a few things. If you could share with us a link to this site, I'm sure I (or someone else) will be able to help further


    Danvers
    Forum|alt.badge.img+12
    • DanversZapier Staff
    • Zapier Staff
    • 3731 replies
    • January 27, 2020

    Hi @Vinnie! You can certainly take a csv and upload it to a database using Zapier, the tricky bit will be downloading it from the website.

    I think you'll likely have to download the file to somewhere like Google Drive/Dropbox and then Zapier can take over and automate things from there.

    Let us know if you'd like some more detail on how that would work!


    BlakeBailey
    Forum|alt.badge.img+1
    • BlakeBaileyConnector
    • Connector
    • 32 replies
    • January 28, 2020

    A lot of the time, websites that provide CSV files to download, can then be accessed via an API request. I'd go to the site, open up your developer tools, (right-click -> inspect in Chrome or Option+Cmd+C), go to 'Network', and then click to export the CSV. If it isn't a button, just keep the inspect tool open and then visit the site.

    As Saastronomical mentioned above, please post the site link (if possible) and we can investigate further. If a request is possible, you can then use the Webhooks by Zapier utility to grab the CSV (maybe).


    V
    • Vinnie
    • Author
    • 1 reply
    • January 31, 2020

    Thank you. I will give your input a try. Have a great day!


    Liz_Roberts
    Forum|alt.badge.img+8
    • Liz_RobertsZapier Staff
    • Zapier Staff
    • 1366 replies
    • Answer
    • March 31, 2020

    Hi @Vinnie ,

    Circling back to summarize the above suggestions and to make sure you were able to automate this workflow!

     

    Solutions summary:

    • Download file (to GoogleDrive/Dropbox) for Zap to access

    OR

    • Access via API request (opening up dev tools→ Network → Export CSV/keept inspection tool open while visiting site)  

     

    Please let us know if you have any additional questions!

    Terms & Conditions