Skip to main content

Shopify product create event create new row in Google Sheets

Shopify is a popular e-commerce platform that enables individuals and businesses to create and manage online stores.

By employing Vanus Connect, you can automatically add new products in your Shopify store to Google Sheets spreadsheet as a new row.

This guide is designed to assist you in setting up a system where you can add new products in your Shopify store to Google Sheets spreadsheet as a new row.

Getting Started​

Step 1: Configure the Source​

  1. Log in to Vanus Connect

  2. Choose the Create new shopify Product data in Google Sheets template. Click on Try it now①.

shopify_google-sheets_5

  1. Give the Conncection a Name②

shopify_google-sheets_2

  1. Click Next③.

shopify_google-sheets_3

Step 2: Obtain Google Sheets Spreadsheet ID and Configure the Sink​

  1. Sign In to Google Sheets and create a new Sheet.

  2. Copy① the Spreadsheet ID.

shopify_google-sheets_8

  1. For the Sink Configuration, Authenticate② with Google, Paste the Google Spreadsheet ID③, provide the Sheet Name④, and Click on the Submit⑤ button.

shopify_google-sheets_4

Step 3: Configure Vanus Connect to receive Shopify events​

After creating the connection in Vanus Connect, we have to configure our connection to receives events from our Shopify Store.

  1. Click on the connection name①.

shopify_google-sheets_10

  1. Copy② the Webhook URL.

shopify_google-sheets_9

  1. Navigate to your Shopify Admin Dashboard and click on the Settings③ button.

shopify_google-sheets_11

  1. Click the Notification④ menu on the sidebar.

shopify_google-sheets_12

  1. Click on the Create webhook⑤ button.

shopify_google-sheets_13

  1. Select the Event⑥, Paste the Webhook URL in the URL⑦ field, select the Webhook API version⑧, and click the Save⑨ button.

shopify_google-sheets_14

Result Display​

When a user pays for a product in your Shopify Store, the Order is automatically added to as new row in Google Sheets.

shopify_google-sheets_7