How to save an Airtable view as CSV to Google Drive or Dropbox on a schedule

Updated 23 October 2026

You want a fresh CSV of an Airtable view to appear in a Drive or Dropbox folder every week or month, so a spreadsheet, an accountant or a backup routine can pick it up. Airtable does not do that on its own. This guide lists the options that exist, what they cost in setup and money, and one route that works without code: have the CSV emailed, then save the attachment.

What Airtable can and cannot do by itself

An Airtable automation can run on a schedule (the At scheduled time trigger supports minutes, hours, days, weeks and months). The question is the action that follows. According to Airtable's help center, the Google Workspace actions are Google Docs create or update (the document is saved in a Drive folder you choose), Gmail send email, Google Sheets append a row, Calendar events and Forms responses. They are available on paid Airtable plans. None of them uploads a CSV, and there is no Dropbox action. The Drive and Dropbox entries in Airtable's integrations list are attachment pickers for pulling files into a record, which is the opposite direction.

Scripts have hard limits too. The Scripting extension only runs when someone clicks Run, so it cannot be scheduled. The Run a script automation action can be scheduled but is unavailable on the Free plan. Its limits: a 30-second timeout (Airtable says it temporarily raised this to 120 seconds for testing), 30 seconds per fetch call, 50 fetch requests, 30 record queries and 512 MB of memory per run. Our script guide builds the CSV text.

The options compared

Option	Gets a CSV into Drive/Dropbox?	Effort	Cost model
Download by hand, drag into the folder	Yes	Someone must remember, every time	Free
Airtable automation with Google Docs or Sheets action	A Google Doc or Sheet rows in Drive, not a CSV	Low, but you get a Doc or a row per record	Paid Airtable plan
Airtable script that calls the Drive or Dropbox API	Yes	High: OAuth, tokens in secrets, paging, retries, 30 to 120 second limit	Paid Airtable plan
Zapier or Make, straight from Airtable	Yes	Medium: search records, build CSV, upload	Zapier tasks or Make credits per step; large views use many
Backup tools (for example On2Air) or EasyCSV	Yes, direct to Drive or Dropbox	Low	Subscription; backups cover whole bases
Email the CSV, then save the attachment	Yes	Low: two small setups	ViewCourier plan plus a free Apps Script or one task a run

Zapier and Make straight from Airtable

On Make the chain is typically Airtable Search records, Create CSV, then Google Drive or Dropbox Upload a file. Zapier has templates that create a CSV from Airtable records and upload it to Google Drive. Zapier counts every successful action step as a task; its Free plan has 100 tasks a month and two-step Zaps, and multi-step Zaps need Professional (from $19.99 a month billed yearly, 750 tasks). Make counts a credit per module run, with 1,000 credits free and paid plans from $9 a month for 10,000 (October 2026 prices).

The catch is volume. A search step that returns hundreds of records is processed record by record, so a large view can cost many tasks or credits per run, and column mapping is manual. Read the usage in the run history after a test before trusting the free tier. See our Zapier and Make comparison.

Backup and import tools

As described in the On2Air comparison, On2Air Backups delivers to Google Drive, OneDrive, Dropbox and Box, but it backs up whole bases rather than one filtered view. EasyCSV can also deliver to Drive or Dropbox (comparison). For a complete base copy, start there, and see automatic CSV backups. For one filtered, sorted view, the email route below is simpler.

The email route: ViewCourier, then save the attachment

ViewCourier is an option, not the only one. It emails the view as a CSV, Excel or PDF attachment on a daily, weekly or monthly schedule (hourly on Pro) to up to five recipients. It does not upload to Drive or Dropbox. Because the result is an email, any tool that can read your mailbox can file the attachment. The monthly or weekly Free plan covers one export of up to 1,000 rows; Starter at €9 gives 3 exports of 5,000 rows and Pro at €19 gives 25 exports of 50,000 rows.

Step by step

Make a dedicated Airtable view. Filter it, sort it and hide the columns you do not want in the file. ViewCourier exports the view's visible fields in the view's order.
Create the export in ViewCourier. Sign in, paste a read-only Airtable personal access token, choose the base, table and view, pick CSV, set the schedule, hour and timezone, and add your own address as recipient. Press Send now to test.
Keep a date in the filename. The default template is {view}-{date}.csv, which gives names like Orders-2026-10-26.csv. Placeholders are {view}, {table}, {base}, {date} and {time}. A dated name stops one month overwriting the last in Drive.
Add the saving step. Pick one of the three below.

A. Google Drive with Apps Script (free, no extra service)

Gmail filters cannot save attachments to Drive, but Google Apps Script can. At script.google.com create a project in the same Google account that receives the export and paste this, replacing the folder ID (the last part of the folder's URL):

function saveViewCourierExports() {
  const folder = DriveApp.getFolderById('YOUR_FOLDER_ID');
  const done = GmailApp.getUserLabelByName('saved-to-drive') || GmailApp.createLabel('saved-to-drive');
  const query = 'from:exports@viewcourier.com has:attachment -label:saved-to-drive';
  GmailApp.search(query).forEach((thread) => {
    thread.getMessages().forEach((m) => m.getAttachments().forEach((a) => folder.createFile(a)));
    thread.addLabel(done);
  });
}

Run it once to grant permissions, then open Triggers and add a time-driven trigger, for example hourly. The label makes each email save once. The dated subject keeps each run in its own Gmail thread; if you drop the date from the filename, test that new runs are still picked up.

B. Dropbox or Drive with Zapier

Create a Zap with the Gmail New Attachment trigger (it fires once per attachment), search keywords such as the sender address, and an action of Dropbox Upload File or Google Drive Upload File. A two-step Zap fits Zapier's Free plan; the trigger is free and the upload is one task. Free plans poll about every 15 minutes. Alternatively use Email by Zapier: forward the export to your Zapier address and upload its attachment, as Zapier's Dropbox tutorial does.

C. Make or Power Automate

In Make, a Custom mailhook gives you an address; forward the export to it (emails up to 25 MB) and add an iterator over the attachments and a Drive or Dropbox upload. In Microsoft 365, Power Automate's When a new email arrives (V3) trigger with Include Attachments set to Yes can feed a OneDrive for Business Create file action; Dropbox and Google Drive connectors exist too, though some connectors need a paid licence.

Things that go wrong

Large files. Attachments above a few megabytes are zipped, and above that the email holds a seven-day download link rather than a file. A workflow that reads attachments will then find nothing, so keep the view small.
Revoked tokens. If Airtable access fails, ViewCourier emails the owner a failure notice instead of a file, so nothing reaches Drive that period.
Empty views. Tick Don't send scheduled emails when the view has no records if an empty file is noise.
Folder permissions. Files created by a script belong to the account that ran it. Share the folder with the people who need it.

Which to pick

Need a full base backup in Drive or Dropbox: a backup tool. Comfortable building scenarios with small views: Zapier or Make directly. Need one clean view as CSV on a schedule with the least upkeep: email it and file the attachment. If a live Google Sheet works as well as a file, the Sheets guide covers a live CSV link with IMPORTDATA. The basics are in how to export an Airtable view to CSV automatically, and why Airtable cannot attach a CSV explains the email step. For a one-off copy of every table, try the free base to CSV tool.

FAQ

Can ViewCourier save the CSV straight into Google Drive or Dropbox?

No. ViewCourier delivers by email only: each run attaches the file to an email sent to up to five recipients. To land the file in Drive or Dropbox you add a second step that saves the attachment, such as a Google Apps Script, a Zapier or Make workflow, or Power Automate.

Does an Airtable automation have a Google Drive action that uploads a CSV?

Not according to Airtable's help center. The Google Workspace actions create or update Google Docs (saved to a Drive folder), append rows to a Google Sheet, send Gmail, and create calendar events and form responses. Nothing turns records into a CSV file or uploads an existing file to Drive or Dropbox. A Run a script step with fetch() can call the Drive or Dropbox API, but you build and maintain that code yourself.

Can a Gmail filter or Outlook rule save an attachment to Drive or Dropbox on its own?

Not by itself. Gmail filters can label, archive, star or forward a message, and Outlook rules can move or forward it, but neither has a save-attachment-to-cloud-storage action. Pair the filter or label with Apps Script, Zapier, Make or Power Automate, which do the saving.

What happens if the CSV is too big to attach?

ViewCourier zips a large CSV first. If it still does not fit in the email, the message contains a download link (valid for 7 days) instead of an attachment, and a workflow that only looks at attachments will not see a file. Keep the view lean, with fewer rows or columns, so the file stays small enough to attach.

How many Zapier tasks or Make credits does the email route use?

One saved file per run. On Zapier the Gmail New Attachment trigger does not count and the Drive or Dropbox upload is one task, so a monthly export uses one task a month. On Make, the mail trigger, any iterator and the upload each count as a module run, so expect a few credits per email. Both fit inside the free plans (Zapier 100 tasks, Make 1,000 credits per month). Check current limits on their pricing pages.

Let ViewCourier do it

Connect a read-only Airtable token, pick a view, and choose daily, weekly or monthly at your time and timezone. Every run emails a clean CSV, Excel or PDF file to up to five people. Free plan for one weekly or monthly export; the 14-day trial of daily schedules needs no credit card.

Start free trial