Integrate Google Sheets with Shopify Using Pabbly Connect: A Step-by-Step Guide

Learn how to seamlessly integrate Google Sheets with Shopify using Pabbly Connect for automated product updates without coding. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Sheets and Shopify Integration

To start our integration process, we need to access Pabbly Connect. Open your browser and navigate to the Pabbly Connect homepage. Here, you will find options to sign in or sign up for free if you are a new user.

Existing users can click on the sign-in button. New users can create an account in just two minutes. After signing in, you will be directed to your dashboard, where you can manage your workflows and create new ones for integrating Google Sheets and Shopify.

2. Creating a Workflow in Pabbly Connect

Once logged into Pabbly Connect, click on the ‘Create Workflow’ button. You will see a dialog box prompting you to name your workflow. Name it something like ‘Update Shopify Products from Google Sheets’ and select a folder to save it in.

• Click on ‘Create’ to initiate the workflow.
• You will see two windows: one for the trigger and one for the action.

In this workflow, we will set Google Sheets as the trigger and Shopify as the action. This allows updates in Google Sheets to automatically reflect in your Shopify store.

3. Setting Up Google Sheets as the Trigger

To set Google Sheets as the trigger in Pabbly Connect, select it from the list of available applications. You will then need to select the trigger event, which in this case is ‘New or Updated Spreadsheet Row’. This event will trigger the workflow whenever there is an update in your Google Sheets.

After selecting the trigger event, a webhook URL will be provided to you. Copy this URL, as it will be used to connect Google Sheets to Pabbly Connect.

• Open your Google Sheets and navigate to ‘Extensions’ > ‘Add-ons’ > ‘Get Add-ons’.
• Search for ‘Pabbly Connect Webhooks’ and install it.
• Once installed, refresh your Google Sheets to see the Pabbly Connect options.

Next, go to the initial setup of the add-on and paste the copied webhook URL. You will also need to specify a trigger column that will notify Pabbly Connect of updates, such as the inventory column.

4. Connecting Shopify in Pabbly Connect

Now, we will set Shopify as the action application in Pabbly Connect. Choose Shopify from the action application list and select the action event ‘Update Product’. To connect your Shopify account, click on ‘Connect’ and provide the necessary API credentials.

For this, you will need to create a private app in your Shopify account. Go to your Shopify settings, click on ‘Apps and Sales Channels’, then ‘Develop Apps’. Here, you can create a new app, name it, and configure API scopes.

Select all relevant product scopes to allow the app to manage product updates. Copy the API access token generated after saving the app.

Paste this token back into Pabbly Connect to establish the connection with Shopify.

5. Finalizing the Integration and Testing

After connecting both Google Sheets and Shopify in Pabbly Connect, it’s time to finalize the integration. You will need to map the product details from Google Sheets to Shopify, including product ID, title, price, and inventory quantity.

Once you have mapped all necessary fields, send a test request to ensure that the integration works seamlessly. After a successful test, you can make updates in Google Sheets and check if they reflect in your Shopify store automatically.

For example, if you update the inventory of a product in Google Sheets, the same update will appear in Shopify without any manual intervention. This automation streamlines your e-commerce operations significantly.

Conclusion

Integrating Google Sheets with Shopify using Pabbly Connect allows for automated product updates. This process eliminates manual efforts, ensuring your store always reflects accurate inventory levels.