跳到主要内容

Shopify orders paid 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 paid orders to your Google Sheets spreadsheet as a new row.

This guide is designed to assist you in setting up a system where you add paid orders to your Google Sheets spreadsheet as a new row.

Getting Started​

Step 1: Configure the Source​

  1. Log in to Vanus Connect

  2. Choose the Add new paid Shopify orders to Google Sheets rows template. Click on Try it now①.

shopify_google-sheets_1

  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_6