Issue with Google Sheet ID Referencing and Mapping Options

·

When referencing Google Sheet ID from another column mapping option does not appear and the action fails when run. This might not be even possible or intended to used this way, but I want to think this is a bug since it is allowed to be referenced. Error basically is clear since mapping didn't show up this was expected.

2 comments

Channeled
APP
·
·
When referencing a Google Sheet ID from another column, mapping options may not appear because you might be using the wrong Google account for the integration. Try removing the connection and reconnecting with the correct Google account that has access to the sheet. For Google Sheets actions to work properly, you need to: 1. Select the correct Google account 2. Paste the spreadsheet URL 3. Select the Sheet ID directly 4. Map columns manually Referencing Sheet IDs from other columns isn't explicitly supported in our documentation.
Source: Google Sheets integration overview | Documentation | Clay University
Robert R.
·
·
I am using the correct account and all connections are working. Thanks.