Skip to main content
Best answer

Update Airtable fields after detecting new file in folder

  • December 22, 2020
  • 4 replies
  • 125 views

I have a number two websites that I download spreadsheets from regularly that I would love to create automated processes with. 

For instance my bank transactions can be downloaded as a csv or excel sheet. I would like to download a set of transactions to a folder and have Zapier automatically create records for those transactions in an Airtable without me having to open and clean up the file headers.

(It’s a small local bank so I am sure they won’t be working with Zapier soon.)

Is this doable? I’d also love to use this kind of zap for things like inventory reports from Squarespace.

Best answer by jesse

Just closing the loop on this! @Ennes and @Troy Tessalone both offered some great insight into things to try as next steps:

 

Ennes wrote:

Hey @StrangeChild,

sounds super interesting! I think as a trigger you could use the Google Drive Folder to which you save this file. Anytime you put a file (in your case your csv) to this particular folder this should trigger a Zap.

In a next step you can create an Airtable Create Record action.

Troy Tessalone wrote:

 

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.

4 replies

Ennes
Forum|alt.badge.img+5
  • Tinkerer
  • 130 replies
  • December 22, 2020

Hey @StrangeChild,

sounds super interesting! I think as a trigger you could use the Google Drive Folder to which you save this file. Anytime you put a file (in your case your csv) to this particular folder this should trigger a Zap.

In a next step you can create an Airtable Create Record action.

Can you work with that?


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30893 replies
  • December 22, 2020

  • Author
  • Beginner
  • 1 reply
  • December 22, 2020

Thanks @Troy Tessalone ! Thanks @Ennes !

I’m going to experiment with the Google drive trigger. 


I’m really good at forming the if then statements for these kind of zaps in my head but I don’t always know the right language to use.

“If thing one does stuff then update the other thing” is probably not going to work. 


jesse
Forum|alt.badge.img+9
  • Architect
  • 1348 replies
  • Answer
  • March 2, 2021

Just closing the loop on this! @Ennes and @Troy Tessalone both offered some great insight into things to try as next steps:

 

Ennes wrote:

Hey @StrangeChild,

sounds super interesting! I think as a trigger you could use the Google Drive Folder to which you save this file. Anytime you put a file (in your case your csv) to this particular folder this should trigger a Zap.

In a next step you can create an Airtable Create Record action.

Troy Tessalone wrote: