How to integrate Google Sheets with Paddle to automatically create products in Paddle when data is added to Google Sheets

Step 1: Register My Apps for Google Sheets and Paddle

Let's register My Apps to connect Google Sheets and Paddle to Yoom.
Registering My Apps in advance makes automation settings easy.

Let's register My Apps for Google Sheets.
Click "My Apps" → "New Connection" on the left side of the Yoom screen.

The following screen will be displayed, so search for Google Sheets in the search bar or find it from the list.

When the following screen appears, sign in to Google Sheets.

Next, let's register My Apps for Paddle.
Similarly, find Paddle from the list or search for it in the search bar.
When the following screen appears, check the instructions and set the "Account Name" and "Access Token".

Once both My Apps registrations are complete, Google Sheets and Paddle will appear in My Apps.

Step 2: Copy the Template

To set up automation, click "Try it" on the banner below.

Read the following screen display and click "OK".

When the following screen is displayed, check "Title" → "Description".
If you want to make changes, please do so from the following page.
First, to set up Google Sheets, click "When a row is added".

Step 3: Set the trigger for the Google Sheets that starts the flow and the subsequent Paddle operation settings

The following screen will be displayed, so check the settings.

• "Title" → Can be changed as desired
• "Account information linked with Google Sheets" → Check if the account is correct
• "Trigger Action" → When a row is added
  

Check the following settings method.

Move to Google Sheets and register the product item names for testing.

Return to the Yoom screen and make the settings.

• "Trigger Interval" → Choose from 5 minutes, 10 minutes, 15 minutes, 30 minutes, 60 minutes
  * The trigger interval varies depending on the plan, so please be careful.
• "Spreadsheet ID", "Sheet ID" → Select from candidates or check the description to set
• "Table Range (Start)" → In this case, A
• "Table Range (End)" → In this case, E
  * Specify the alphabet of the last column of the item
• "Column with Unique Values" → Specify the column where values do not duplicate within the column
  * Ensure there is a column with unique values.
  If values are duplicated, it may not work correctly, so be careful.
  In this case, we specified column A for ID, but you can specify any column.

Once the settings are complete, click "Test" → "Test Successful" → "Save".

Next, to set up Paddle, click "Create New Product".
When the following screen is displayed, check the settings.

• "Title" → Can be changed as desired
• "Account information linked with Paddle" → Check if the account is correct
• "Action" → Create New Product
  

When the following screen is displayed, set the "Product Name".
The output field of "When a row is added" will display the item names set earlier.
Select the product name from the output.
You can select from the output by clicking the arrow within the red frame.

Scroll and use the output of "When a row is added" to set other items configured in Google Sheets.
Once the settings are complete, click "Test" → "Test Successful" → "Save".

Next, to set up updating records in Google Sheets, click "Update Record".
When the following screen is displayed, check the settings.

• "Title" → Can be changed as desired
• "Account information linked with Google Sheets" → Check if the account is correct
• "Execution Action" → Update Record
  

Scroll and set up "Database Integration".

• "Spreadsheet ID", "Spreadsheet Tab Name" → Select from candidates or set as per the description
• "Table Range" → Set as desired
  

When the following screen is displayed, set the "Conditions for the record you want to update".
Here, use the unique value present at the trigger point to search for the target record.
This time, we set it as follows.

Scroll and set the "Values of the record after update".
Since we will update the Product ID obtained from Paddle, use the Paddle output to set as follows.
Once the settings are complete, click "Test" → "Test Successful" → "Save".

Step 4: Turn on the trigger button and check the integration operation between Google Sheets and Paddle

Finally, click "Turn on Trigger" to complete the automation settings.
Check if the flow bot starts correctly.

Here is the template used this time.

Other Automation Examples Using Google Sheets and Paddle

1. This is a flow where a new customer is automatically created in Paddle when a row is added in Google Sheets.
‍This eliminates the need to manually add new customers to Paddle, saving time and effort.
Reducing human error allows for accurate registration of new customer data.

2. This is a flow that automatically creates a new transaction in Paddle when a row is added to a Google Spreadsheet.
It is recommended for those who want to reduce the manual effort of adding new transactions to Paddle every time they are added to a Google Spreadsheet.
Data entry is done quickly, enabling smooth operations.

3. This is a flow to automatically add Google Form responses to Google Sheets.
You no longer need to manually add Google Form responses to Google Sheets.
Managing form content in Google Sheets makes it easier to review.

Summary

Manual registration of product data is time-consuming and prone to errors.
However, by integrating Google Sheets with Paddle, registration can be automated, preventing registration errors and ensuring accurate data entry.
This centralizes the management of product data, streamlining the workflow.
This automation is especially recommended for companies that frequently launch new products.

Implement the template introduced here to simplify the management of product data.