Connect Google Sheets to Shopify Using Flowfy App – Easy Integration Guide

Flowfy is a Shopify app that allows you to automate and integrate your Shopify store with Google Sheets, enhancing data management and workflow efficiency. It helps you save time and effort by connecting your Shopify store with Google Sheets to automatically log and organize data.

Authorization of Google Sheets to Shopify using Flowfy App

To integrate Google Sheets with Flowfy, open your Flowfy dashboard and click on the “Create Integration” button. This will take you to the Trigger page, where you can select a trigger from the list. After choosing your trigger, proceed to the next step, and you’ll be directed to the Action page. On this page, search for and select “Google Sheets” from the available actions.

???? There are two ways you can connect with Google Sheets:

• Connect with OAuth
• Connect with Client ID

Connect with OAuth

To connect Google Sheets using OAuth method, follow these steps:

• Click on “Connect with OAuth”.
• Select your Google account.
• Click on “Advanced.”
• Click on “Go to flowfy.io“
• Click on “Continue.”
• Grant the necessary permissions (for this example, all permissions are selected).
• Your connection to Google Sheets is now successfully established.

Connect with Client ID

First, click on Connect with Client ID.

You will now be prompted to enter your Client ID and Client Secret.

To obtain your Google Sheets Client ID and Client Secret, follow these steps:

1. Create a Project:

• Visit the Google API Console and initiate a new project.
• Assign a suitable name to your project and click “Create.”

2. Enable APIs:

• Now, go to “APIs & Services.”
• Search and enable both the Google Drive API and the Google Sheets API.

3. Configure OAuth Consent Screen:

• After enabling the API, go to the “OAuth Consent Screen.”
• Choose “External” as the user type and click “Create.”
• Provide details for your app, including a name, support email, and developer contact information then click on “Save and Continue“.
• In the scope section, click on “Add or Remove Scopes.” Add these scopes. Then, click on “Update.”
  1. https://www.googleapis.com/auth/drive
  2. https://www.googleapis.com/auth/drive.file
  3. https://www.googleapis.com/auth/drive.metadata
  4. https://www.googleapis.com/auth/spreadsheets
  5. https://www.googleapis.com/auth/userinfo.profile
  6. https://www.googleapis.com/auth/userinfo.email
• Progress through the consent screen setup by clicking “Save and Continue” until you reach the dashboard.
• Publish your app and confirm the action.

4. Generate Client ID and Client Secret:

• Now, go to the “Credentials” section and click “Create credentials” followed by “OAuth Client ID.”
• Select “Web Application” as the Application type and assign a name.
• Under “Authorized JavaScript origins,” add your “Homepage URL“.
• Under “Authorized redirect URIs,” add the authorized redirect URIs from the integration page.
• Click “Create.”

5. Obtain and Utilize Credentials:

• Your Client ID and Client Secret will now be displayed.
• Copy these credentials and paste them into the appropriate fields on the integration page.

Once you have successfully entered your Google Sheets Client ID and Client Secret, click “Connect” to proceed. Then follow these steps:

• Select your Google account.
• Click on “Advanced.”
• Click on “Go to flowfy.io“
• Click on “Continue.”
• Grant the necessary permissions (for this example, all permissions are selected).
• Your connection to Google Sheets is now successfully established.

Spreadsheets: Select a Spreadsheet from the drop-down option.

Worksheet: Select a Worksheet from the drop-down option.

Header Row: Specify your header row, for instance, A1.

In the Google Sheets integration settings, you’ll find a “Map Fields” option. This allows you to map trigger fields with action fields.

Conditional Logics

This feature lets you set conditions for the integration. Data will only be sent to Google Sheets when those conditions are met. For more details, check our documentation on conditional logic. Once you’ve set up your conditions, click Next to proceed.

First, click on “Condition,” then enable the option “Would you like to set a condition to trigger the action?” Next, define your custom condition.

Google Sheets Integration Save

Once you have configured the desired settings for the integration, click the Save Changes button to save the integration.

You can view all the integrations you’ve created. To do this, click on “Integrations” under Flowfy in the left-hand menu.

Integration Log

To view the integration log, click on “Activity” under Flowfy in the left-hand menu. Here, you can filter the logs by All Logs, Success Logs, Missing Logs, and Failed Logs.

Check out our easy-to-follow tutorials!

• Connect Google Sheets to Shopify Using Flowfy App