Skip to content

Copy specific CSVs from shared folder to data lake

Automatically detect new files in Google Drive shared folders across Google Drive, Filter by Zapier, and Amazon S3. Create and update when new CSVs arrive, filenames match your campus naming, or uploads complete—so you can upload to your data lake, overwrite the latest report version, and skip non matching files without manual file handling.

How this automation uploads CSVs to your data lake

When new files land in a shared folder, delays can stall pipeline ingestion and keep datasets out of date. This automation monitors folder activity, filters for the right CSV naming pattern, and uploads matching files to Amazon S3—so your team can keep data fresh quickly.

  1. 1.Monitor new files in folder

    Integrate Google Drive and file storage connectors to detect new files and pull file metadata and content.

    Google Driveor swap with your favorite app
  2. 2.Filter for matching CSV files

    Integrate Filter by Zapier and validation rules to continue only when the file has a CSV extension and naming pattern.

    Filter by Zapieror swap with your favorite app
  3. 3.Upload CSV to Amazon S3

    Integrate Amazon S3 and data lake storage to upload the CSV with object keys and the text/csv content type.

    Amazon S3or swap with your favorite app

Automate your work, your way

Build custom automations across your tools in minutes. Describe what you need, connect your apps, and create workflows without the manual effort.

Start with Copilot

Trusted by 3.4 million companies

Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable
Calendly
Okta
Zendesk
Dropbox
Asana
Allstate
Airbnb
ActiveCampaign
Lyft
Webflow
Canva
Sysco
LA Clippers
Getaround
Grammarly
HelloFresh
Lululemon
Barry's
Hopper
Casper
Hudl
Miro
The New York Times
Ruggable

Related automations

  • Apps: Amazon S3
    Swap with your favorite apps.

    Copy new inventory files to ETL-ready storage bucket

    Your inventory pricing files land in a supplier bucket and never reach ETL, leaving product prices stale. The workflow moves files to ETL storage so pricing updates run reliably before nightly feeds.

  • Apps: Amazon S3, OneDrive
    Swap with your favorite apps.

    Create cloud drive copies of new storage files

    Booking export files land in object storage, leaving ops and reporting without updated dashboard data. Save copies to your shared drive so IT and operations have updated files for dashboards same day.

  • Apps: Zoom, Delay by Zapier, Webhooks by Zapier
    Swap with your favorite apps.

    Deliver meeting transcripts and metadata to processing API

    Your meeting recordings and transcripts can sit unprocessed, delaying searchability and insights. Deliver them to your processing API so they’re indexed and available within minutes.

  • Explore all data transfer automations

    Accelerate data movement with automated file routing, export handling, and record transfers

    View all

Set up in minutes

Zapier connects your tools, triggers actions from real-time data, and streamlines workflows so your team can focus on what matters most.

  1. Step 1

    Connect your tools

    Bring your apps together so information can move automatically between the tools your team already uses.

  2. Step 2

    Define the trigger

    Choose the events that should start your workflow, like a new submission, updated record, completed task, or customer action.

  3. Step 3

    Automate and measure

    Let your workflow handle follow-ups, updates, notifications, and reporting so your team can track progress and act faster.

See how teams are automating with Zapier (and loving it!)

Smart Charge America

Without Zapier, we would have needed well over 100 employees today just to do what we're doing. We would have been out of business by now.

David Laderberg, VP of Sales

Remote

Without having automation, we would have to at least be double our size. Doubling is a bit of a euphemism — I think we would have died or fallen back into oblivion.

Marcelo Lebre, Co-Founder

SweepBright

Zapier helps us close far above 50% more deals than we would without it. It is a key element of our overall strategy and, therefore, of our sales pitch.

Raphael Bochner, Founder and CIO

Digioh

Zapier gives us unlimited flexibility and creativity. With Zapier, you're like an artist with a blank canvas. I don't know what we'd do without it.

Rishi Shah, CEO and Co-Founder

Otter.ai

We don't just want to patch holes; we want to build scalable, future-proof systems. Zapier is helping us do that.

Allen Lai, Head of Customer Experience

Superhuman

We've been able to scale our operations while staying lean. Zapier lets us do more without needing more people.

Jacob Sirrs, Marketing Operations Specialist

Ready to automate your workflow securely?

Streamline processes, uncover new opportunities, and respond faster to change. Empower your team to get more done, without the manual work.