› Integrations › Connections

Sheets Connector

Official

Sync rows from Google Sheets or Excel straight into your AJEMS workspace.

Spreadsheets
Category
One-way data sync
Data flow
~5 min
To set up
All plans
Availability

Setup

Connect your sources

Connect your AJEMS workspace to sign in, then connect Google or upload a spreadsheet. Everything you set up stays private to your workspace.

2 steps ~5 minutes One-way sync
1 AJEMS
Not connected

Just the tenant name is enough. A full URL works too - if you paste the browser address by mistake, the app finds the API host itself.

In AJEMS under Settings › JSON Builder. This is also how you sign in: only someone with the key can see this workspace's tasks.

2 Google Sheet / Excel sheet
Not signed in

Where your rows come from. Connect Google to sync sheets on a schedule, or upload an Excel file to import it once. You can use both.

or
Sync

Tasks

One task takes one sheet tab into one AJEMS form, from a Google Sheet or an uploaded Excel file. Add as many as you need; they run independently.