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
I met with Salesforce support. The option given to me was to suspend the MFA security changes from last month for 90 days. It was implied that google was aware of the issue and that it would likely be resolved before the 90 days was up.
