Impora
SharePoint → Airtable · governed document libraries

One SharePoint library, the same governed path into Airtable.

SharePoint is where teams keep the documents everyone works from. Point Impora at one library folder and the recurring file lands in Airtable the same governed way every cycle, mapped, validated, and logged.

Connect a SharePoint library →See how it connects

Sign in once with Microsoft · scoped to a single folder · .csv, .xlsx & .xls

SharePoint library
Watching
Shared Documents / Monthly imports
oct-prices.xlsx
Impora
1Map fields
2Validate rows
3Auto-pickup
Airtable base
142 rows
Same rules, every cycleUp to 100k rows per runImport · export · roundtrip

Four steps, once

Set it up once. It repeats itself after that.

1

Sign in with Microsoft

Authorize Impora with your Microsoft 365 account and scope it to a single SharePoint library folder, no shared logins.

2

Pick the library and table

Choose the document library folder that holds the recurring file and the Airtable table it should feed.

3

Attach template rules

Reuse saved field mapping, validation, and Airtable schema behavior, including linked records.

4

Turn on automatic import

Impora checks the library every 15 minutes and imports any new file automatically, or run it by hand.

A straight recommendation

Is SharePoint the right lane for this workflow?

SharePoint is the right home when files live in a shared, governed library, multiple contributors and IT-managed permissions. It is worth being honest about where it fits and where a lighter Microsoft lane serves you better.

Best fit

Shared library, many contributors

Reach for SharePoint when files live in a governed document library that several people or departments contribute to.

Also strong

IT-managed permissions

When access is controlled by Microsoft 365 groups and IT owns the permissions model, SharePoint keeps Impora inside that boundary.

Lighter lane

One owner? OneDrive may be simpler

If a single person owns one recurring spreadsheet, a personal OneDrive folder is often the quicker place to start.

See OneDrive to Airtable →

The shared-library trade-off

A shared library many people touch still feeds one base the whole team relies on.

!The hidden risk
✓How Impora removes it
Lots of people can drop files in the library, but the Airtable base they feed affects the whole team.
The library feeds Airtable on one saved template, so every file lands the same validated way, whoever added it.
A shared library quietly becomes a production workflow, with no record of what imported and when.
Mode, library, and auto-pickup are written into the connector config, and every run is logged, documented, not remembered.
A bad row spreads through Airtable views and automations before anyone notices.
Every file is validated on arrival; failed rows are held with an error report before they reach the base.
Governed exports still need visible status and a delivery history.
Run history shows what ran, what imported, and what failed, for imports and exports alike.

The connector config

Mode, folder, auto-pickup and recovery, on one screen, not in one contributor’s head.

app.impora.app · Connector Settings
Mode
ImportExportRoundtrip
Connected folder
Shared Documents/Supplier pricesVerified
Automatic import

Impora checks this folder every 15 minutes and imports any new file that matches your template. Nothing to schedule.

Watching for new filesLast checked 3 min agoNext check in 12 minRun now
Import · export · roundtripAuto-pickup every 15 minutesRun history & error recovery

You authorize one library, that’s the whole boundary.

One library folder, not all of SharePoint

Access is scoped to the single library folder you connect, never the rest of your SharePoint sites or Microsoft 365 account.

Sign in with Microsoft, revoke anytime

No shared password. You authorize once with Microsoft 365 and can remove Impora from your account whenever you want.

The same validation as uploads

Library imports run your saved template rules, required fields, formats, select options, and linked records.

Every file is validated against your Airtable template before a single row is written, a SharePoint library gets exactly the same checks as a manual upload.

SharePoint to Airtable questions

When should I use SharePoint instead of OneDrive?+

Use SharePoint when files live in a shared, governed document library, multiple contributors, several departments, or IT-managed permissions. A single owner with one recurring file may find OneDrive simpler.

How does Impora get access to my SharePoint library?+

You sign in once with your Microsoft 365 account and grant access to a single library folder. There is no shared login, and you can revoke Impora from your Microsoft account at any time.

What file types are imported from the library?+

CSV and Excel files (.csv, .xlsx, .xls) are processed for import. Other file types in the library are ignored rather than imported.

Do new files import automatically?+

You choose. Turn on automatic import and Impora checks the library every 15 minutes, importing any new file as it appears; or leave it manual and run it when you are ready.

Can SharePoint imports validate linked records?+

Yes. Validation follows your saved Airtable template, including required fields, formats, select options, and linked-record behavior where configured.

Can SharePoint workflows include exports?+

Yes. Export and roundtrip connector modes can deposit files back to a connected SharePoint library where configured.

Give the shared library a governed path into Airtable.

Free to start. Files stay in SharePoint where the team works; Airtable gets the same validated import every cycle. Sign in once, scope one library, revoke anytime.

Connect a SharePoint library →See how it connects
OneDrive to Airtable →Google Drive to Airtable →All cloud folders →