Watch · 2-minute setup
Add a Google Drive connection, share the folder with the Impora address, pick the Airtable table and map the fields, then turn on automatic imports. Here is the whole thing in one pass.
Rather read it? See the connector settings below ↓
A shared folder, every week
Suppliers already drop price lists into a shared Google Drive folder. Someone used to open each file, copy it into Airtable, and hope the columns lined up. Here is what changed once that folder became an Impora intake lane.
Every new supplier meant another Airtable guest seat, a shared login, or an operator re-keying their spreadsheet by hand.
Someone had to remember to open the folder, spot the new file, and start the copy-paste before the data was stale.
Malformed rows were discovered days later in Airtable, and untangling them fell on whoever noticed.
The real control surface
Copy the managed Impora address and share the Drive folder with it. No Google login, no browser extension.
Pick a direction per template, pull new files into Airtable, deposit snapshots back out, or both.
Turn on automatic imports and set the cadence. Impora checks the folder and processes what is new.
See what imported, what failed, and when, the same run history as uploads and email intake.
Straight about the access model
A watched folder is convenient, so it is worth being precise about the scope. You grant access to one folder, and that is the whole boundary.
Access is scoped to the single folder you share with the Impora service account. It cannot see anything else in your Google Drive.
Impora never signs into your Google account. It uses a managed service account you grant folder access to, exactly like sharing with a colleague.
Required fields, formats, select options and linked records are checked with the exact rules your direct uploads use, nothing gets a looser pass from a folder.
Imported, held, and skipped files all appear in run history, so a watched folder stays as auditable as any other intake lane.
You share the folder; you own the revoke. Access is a standard Google Drive share with a managed Impora service account, not a login to your Google account. Remove the share and the connection stops immediately. Every file is still validated against your Airtable rules before a single row is written.
No. Anyone with access to the shared Drive folder can drop a file in. Airtable access stays limited to your operators, no seats or logins for the people sending data.
You share the folder with a managed Impora service-account address, the same way you would share it with a colleague. Impora never logs into your Google account, and viewer access is enough for imports.
CSV and Excel files (.csv, .xlsx, .xls) are processed for import. Other file types in the folder are ignored rather than imported.
You choose. Turn on automatic imports to process new files on a schedule as they appear, or leave it manual and run the folder when you are ready.
Valid rows import and failed rows are held with an error report. Correct the file and the next run picks up just what needs fixing, it all shows up in run history.
Folder connectors handle far larger files than the 2,000-row manual upload cap. Included volume is a fair-use guide, not a hard cutoff: 50,000 rows per run on Pro and 100,000 on Business, so larger runs still complete and we reach out before anything is throttled.