What it adds. If your team logs leads in a Google Sheet, OmniCommand can read that sheet directly instead of waiting for a CSV upload. The leads join the analysis alongside your ad and analytics data, and the sheet is read again about twice a day, so new rows arrive without anyone exporting anything.
Before you start. The leads need to sit on one tab, under a header row with the same columns a CSV lead upload uses. Admins and Standard members can connect sources.
Connecting.
- On the Sources page, open Google Sheets and choose Connect Google Sheets. Sign in with the Google account that can open the sheet.
- Choose Pick a spreadsheet. Google's own file picker opens over your Drive; select the spreadsheet.
- Choose the tab that holds the leads, then Use this tab. OmniCommand reads it at once and tells you how many leads it imported.
What OmniCommand can see. Only the spreadsheet you pick. Google gives OmniCommand access to that one file and nothing else in your Drive. Only the person who connected Google Sheets can open the picker again to choose a different sheet.
How it stays current. Each sync reads the whole tab again. An unchanged sheet changes nothing. A changed one replaces the previous read in full, so the leads in OmniCommand always match one moment of the sheet, and its dialog on the Sources page shows when that was.
What the leads add to the analysis. Leads become an outcome OmniCommand can measure and compare over time. When a lead carries an ad click ID (such as gclid from Google or fbclid from Meta), OmniCommand records the platform it came from. A lead carrying click IDs from more than one platform is reported as touching several, never handed to one. A lead with only UTM tags is matched with low confidence, because those tags are self-reported.
One lead source at a time. One sheet per portfolio. While it is connected, it is the portfolio's lead source: picking its tab retires the portfolio's active CSV lead imports, and new CSV lead uploads wait until the sheet is disconnected.
When a read is refused. If a column the analysis needs is renamed or removed, or the tab grows past 50,000 rows, OmniCommand keeps the last good read and says what changed: the missing columns or the row count, when the leads shown were read, and since when the sheet has been refused. Nothing is ever half-imported.
Disconnecting. Disconnect Google Sheets from the Sources page. Stored access is removed and reading stops. Leads already read stay until a CSV upload or another sheet replaces them. Google Sheets counts as one connected source toward your plan's allowance.