About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • Home
  • Get Help
  • How Do I
  • How do I automate copying new folders with CSV files from Google Drive to Amazon S3 using Zapier?
Best answer

How do I automate copying new folders with CSV files from Google Drive to Amazon S3 using Zapier?

  • 6 March 2024
  • 5 replies
  • 33 views
Z

Hello,

 

I’m new to Zapier and trying to figure out how to build a simple workflow:

  • A new folder with x number of CSV files is created in Google Drive;
  • Copy this folder with all contents to Amazon S3.

I’m able to create zaps to “listen” for new folders and create these on S3 (empty folders).

I’m also able to map zaps to updated files (each file individually) within specified folders to upload these to S3.

 

What I’m not able to do is to combine both steps so they work in a dynamic manner, as folder names will always be different and contents within these folders may differ as well.

 

Hope what I’m trying to achieve makes sense.

icon

Best answer by Troy Tessalone 6 March 2024, 17:56

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.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @zap_user_111 

There likely isn’t going to be a “simple” way to do this.

The Zap trigger GDrive New File in Folder requires watching a specific Folder.

That means a separate Zap would need to be configured for each GDrive Folder you want to watch for new files.

 

It may even involve using the GDrive API via one of these advanced Zap actions:

  • Custom Action
  • API Requests
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z

Thanks Troy, just one more question please. Is there a way to reference the parent folder name? At the moment, metadata from from Google Drive trigger returns folder/path IDs, but not the name.

Troy Tessalone
Userlevel 7
Badge +14

@zap_user_111 

Can you provide screenshots of a specific example to help us have more context?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z

Below is an example of metadata output when Google Drive “New File in Folder” trigger is tested. In the following step/zap I’m pulling a file name, but what would also help is to include the parent folder name, as this would allow to create the corresponding folder in Amazon S3, where the file would be uploaded to. At the moment I understand it pulls only folder IDs.

 

 

Troy Tessalone
Userlevel 7
Badge +14

@zap_user_111 

You would have to use another Zap step to get the Parent Folder ID.

Try one of these available actions to get a Folder by ID:

  • Custom Action (w/ AI)
  • API Request

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions