How to Apply the Google Sheets 2.1.0 Update with new redirect url?

The Google Sheets 2.1.0 update brings a significant improvement to the authentication and token refresh mechanism. This update ensures that your Google Sheets integration uses your own site’s endpoint URL for token refresh requests instead of FlowMattic’s central API. This means that if our firewall previously blocked access token refresh requests, you’ll no longer face authentication failures because all requests are now served directly from your website. This enhancement provides greater reliability and stability for your Google Sheets workflows.

Step-by-Step Update Guide

Follow these steps to apply the Google Sheets 2.1.0 update to your FlowMattic installation:

Step 1: Navigate to FlowMattic Integrations

Go to FlowMattic → Integrations from your WordPress admin dashboard.

Step 2: Refresh Available Updates

Click the refresh icon next to the “New Workflow” button a couple of times to check for the latest integration updates.

Step 3: Apply the Update

Once you see the update notification:

1. Switch to the Updates tab
2. Locate the Google Sheets integration update
3. Click the update button to install version 2.1.0

Step 4: Create a New Connect

After the update is installed:

1. Navigate to FlowMattic → Connects
2. Click Connect Integration button
3. Select Google Sheets from the integration list
4. You’ll now see a new endpoint URL in the Callback or Redirect URL field
5. Copy this new URL - you’ll need it for the next step

Step 5: Update Your Google Cloud Console Project

Now you need to add the new callback URL to your existing Google Cloud Console project:

1. Go to the Google Cloud Console
2. Select your existing project (the one you created for FlowMattic)
3. Navigate to APIs & Services → Credentials
4. Locate your existing OAuth 2.0 Client ID credential
5. Click on the credential name to edit it
6. Scroll down to the Authorized Redirect URIs section
7. Click + ADD URI
8. Paste the new callback URL that you copied from Step 4
9. Keep your existing redirect URI (https://api.flowmattic.com/google/spreadsheets) if it’s still there
10. Click Save at the bottom of the page

Important: You can keep both redirect URIs (the old and new one) for a transition period if you have multiple sites or want to maintain backward compatibility.

Step 6: Complete the Authentication

1. Return to your FlowMattic Connect configuration page
2. Copy the Client ID from your Google Cloud Console credential
3. Copy the Client Secret from your Google Cloud Console credential
4. Paste both values into the respective fields in your FlowMattic Connect
5. Click the Save Connect and Authenticate button
6. Complete the Google OAuth authorization flow
7. Once authenticated successfully, save your Connect

Final Step: Update your workflows

1. Edit your workflow using the Google Sheets integration
2. Edit the Google Sheets action step and choose the new connect
3. Save the step and do a test action to confirm the working
4. Save workflow
5. Now, you can delete the OLD connect to avoid the duplicate calls to renew access token, or they will conflict with each other.

What’s Changed?

After completing these steps, your Google Sheets integration will use your website’s own endpoint URL for all authentication and token refresh operations. This architectural change means:

• Improved Reliability: No more failed token refreshes due to firewall restrictions between FlowMattic’s API and Google
• Better Control: All API communication now flows through your own website
• Reduced Dependencies: Your integration is less dependent on external API endpoints
• Enhanced Stability: Workflows using Google Sheets will run more consistently without authentication interruptions

Your existing workflows will continue to work seamlessly with this new authentication mechanism once you complete the update process!