Before you start
- A Google Sheet whose first row contains the column headers.
- At least one column with a phone or an email for every lead you want to import.
- The task that should receive the leads (or write the rows).
Connect from Integrations
1
Open Google Sheets
Go to Integrations → Google Sheets. The first time, the setup opens directly. Once you have connected sheets, select Add sheet.
2
Spreadsheet
Choose Bring leads in or Receive rows from a task, then paste the Google Sheets link. The screen shows the Nexor address to share the sheet with. In Google Sheets, select Share, paste that address and give it Editor access. Nexor confirms when it can open the sheet; if not, select Check again after sharing.
3
Tab and task
Choose the tab and the task. For a sheet that receives rows, describe when the task should add a row, for example “when the lead books a meeting”.
4
Columns
For Bring leads in, Nexor proposes which column fills each lead field (phone, email, name) from the headers. Review it and change any column with Add row or the field selector. Columns you don’t link still arrive as extra lead data, and you can link them to the task’s Variables. For Receive rows from a task, choose which lead data the task writes into each sheet column.
5
Review and save
Check the summary. For an import, choose whether to import the rows already in the tab or only rows added from now on, then select Save sheet.
Manage your sheets
Connected sheets appear under Sheets in a table with the spreadsheet, the task and what happens. Change the task directly in its row. Use the Active switch to pause or resume one; turning an import on asks for confirmation because its task may start contacting the new leads. The ⋮ menu lets you Edit or Remove it. Removing it keeps the leads already imported.
Connect from Nexor AI
Ask Nexor AI, for example “Bring the leads from my Google Sheet into the qualification task”, and paste the link. Nexor AI:- Checks whether it can open the sheet and, if it is private, gives you the address to share it with.
- Asks which tab to use when there is more than one.
- For Bring leads in, shows the proposed column mapping and asks whether to import the rows already in the tab. For Receive rows from a task, asks when to add a row and which lead data to write into each column.
- Connects the sheet paused. For an import, tells you how many rows will become leads. It turns the sheet on only after you confirm.
- Ends with a button that opens the Google Sheets screen.
What the import does
- Rows are read about every five minutes. Google limits and processing time can add delay.
- Each row needs a valid phone (eight digits or more) or a valid email. Rows with neither are skipped and are not retried; add a corrected row at the bottom instead.
- Leads are matched by email first, then by phone, so a lead that already exists is updated instead of duplicated.
- While the task is paused, rows wait and import once it is live again.
Sheets that receive rows
In this mode the task adds a new row each time the task meets your instruction; it never edits an existing row. Choose which lead data goes into each column in the Columns step. Test it with a Playground conversation before putting the task live.Through the API and MCP
The public MCP server exposesget_google_sheets_status, inspect_google_sheet and change_google_sheet_automation, which follow the same rules: a private sheet returns the address to share it with, a new connection is saved paused, and turning it on requires confirm=true after reviewing how many rows it will import.