Hello All,
We are currently facing an issue with the Salesforce Connector for Google Sheets. We have been unable to export Salesforce reports to Google Sheets using the connector.
We are receiving the following error message:
"In order to get all of the report data, disconnect and re-authorize the Add-on from Salesforce using Help > Connection Information > Disconnect Add-on. Once disconnected, log in to Salesforce again using the Add-on."
Based on our initial findings, we suspect that this issue may have been caused by the recent MFA enforcement in the Production environment.
Each time a user tries to export a report, a new verification window opens and asks for an MFA verification code.
We are using the Salesforce Connector and have followed the instructions provided in the error message. After reconnecting, the export works only up to 2,000 records, and then the connection fails again.
Is there any workaround or recommended solution to prevent repeated MFA prompts and allow users to export reports successfully?
#Salesforce Admin #Security #MFA #Salesforce_connector
We are migrating to SOQL, meaning we will use the same Google Connector to query the data directly instead of exporting reports. Because this SOQL export operates via the API rather than the UI, it successfully bypasses the mentioned limitation.
However, please keep the following SOQL specifics in mind:
- Row Limits: Extracts are capped at 10,000 rows.
- Headers: Google Sheets will display field API names instead of standard field labels.
- Formatting: The column order in the sheet may not match the order of fields in your query.
Despite these quirks, this remains a highly effective workaround.
