How to Automatically Add Order Information Created in Squarespace to Google Sheets

When you receive a lot of emails every day, it can be quite a hassle to save files to Dropbox each time.
Moreover, many people might have experienced the struggle of missing a file save or saving a file in the wrong folder, making it difficult to find later.

In this article, we will introduce a method to automatically save files received in Gmail to Dropbox!

By using no-code tools, you can easily set up automation between Gmail and Dropbox.
You can start using it right away, so be sure to give it a try!

Recommended for

Those who want to automatically upload files attached to Gmail to Dropbox
Those who want to integrate Gmail and Dropbox to facilitate smooth file sharing within the team
Those who want to prevent the loss of attachments and ensure proper document storage

For those who want to try it immediately

In this article, we will introduce the integration method using the no-code tool "Yoom".

No complicated settings or operations are required, and even non-engineers can easily achieve it.

You can start right away using the template below, so please give it a try!

Are you manually entering Squarespace order information into Google Sheets?
Let's automate manual tasks with Yoom.
Yoom's app integration and automation require no coding, making it easy for anyone to achieve automation. We highly recommend it for those who have given up on automation due to the complexity of app integration.
This article will set up automation to "add information to Google Sheets when order information is created in Squarespace."

Benefits of Integrating Squarespace with Google Sheets

One of the benefits of integrating Squarespace with Google Sheets is that it makes data management easy, thereby improving work efficiency.
We've highlighted the benefits of app integration below, so please use them as a reference.

Benefit 1: Improved Work Efficiency

Integrating Squarespace with Google Sheets can be expected to improve work efficiency.
For example, when order information is created in Squarespace, it can be added to Google Sheets.
Running an e-commerce site can be challenging just by managing order information.
Especially with manual data entry, there may be times when you want to delegate it to someone else.
By relying on automation like the above, you can eliminate the hassle of entering data into Google Sheets.
This allows you to focus on other tasks such as product management and customer service, which can lead to improved work efficiency.

Benefit 2: Easier Data Management

Another benefit of integrating Squarespace with Google Sheets is easier data management.
When managing order information using multiple applications, the number of times you need to enter data increases, which can increase the workload.
By entrusting data entry to automation, duplication or omission of order information is less likely to occur.
It accurately enters order information, avoiding troubles caused by incorrect information.

Benefits of Integrating Apps with Yoom

Using APIs for app integration is common, but setting it up on your own can be a significant barrier for users who have never encountered programming.
In past API integrations, programming knowledge was essential, and a lot of time was spent on troubleshooting and setup.
However, with Yoom, you can integrate apps without programming knowledge, using no-code.
There are no complex setup methods, so it can be set up in a short time and is easily accessible to anyone.
It can also quickly respond to troubleshooting, so it won't take away your valuable time.

How to Create a Squarespace and Google Sheets Integration Flow

This time, we will introduce the setup of the following template: "Add information to Google Sheets when order information is created in Squarespace."

The setup is completed in 2 steps, so you can easily set it up in 10-15 minutes.

Setting up a flow bot that activates when order information is created
Setting up an action to add records

If you are not using Yoom, please register for free here.
If you are already using Yoom, please log in.

How to Connect Squarespace and Google Sheets with Yoom

Register your own app to link Squarespace and Google Sheets with Yoom.
By registering your own app, you can easily set up automation later.

First, let's start with registering your own app for Squarespace.
Click "My Apps" → "New Connection" on the left side of the screen.
Find Squarespace from the app list or search from "Search by App Name".

The following screen will be displayed, so please configure the settings.

"Account Name" → Set any account name for management purposes, e.g., Administrator Account
"Access Token" → Set the API key issued in the Squarespace admin panel by navigating to "Settings>Developer Tools> Developer API Keys"
※Please allow the following permissions when issuing the API key.

Products - Read and Write
Inventory - Read and Write
Orders - Read and Write
Transactions - Read Only
Profiles - Read Only

Next, register your own app for Google Sheets, and select Google Sheets as you did before.
When the following screen appears, please log in to Google Sheets.

Once both app registrations are complete, Squarespace and Google Sheets will appear in your My Apps section.

How to Add Information to Google Sheets When Order Information is Created in Squarespace

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

The following screen will be displayed, so please check the "Title" and "Description".
If you want to make changes, you can do so from the page below.
First, go to the Squarespace settings and click on "When order information is created".

When the following screen is displayed, please check the settings.

"App Trigger Title" → Set as desired
"Account Information to Integrate with Squarespace" → Check if the account is correct
"Trigger Action" → When order information is created/updated

The following screen will be displayed, so set the "Trigger Activation Interval" as desired.
Click "Test" → "Test Successful" → "Save".

Next, set up Google Sheets by clicking "Add Record".
When the following screen is displayed, please check the settings.

"Title" → Set as desired
"Account Information to Integrate with Google Sheets" → Check if the account is correct
"Execution Action" → Add Record

Before scrolling, set up the Google Sheets where Squarespace order information will be added.
As an example, I have entered the item names below.
Enter the necessary item names from the Squarespace order information.

Scroll through the Yoom screen and set up the "Database Integration".

"Spreadsheet ID" → The ● part in the URL "/spreadsheets/d/●●●●●/edit" is the Spreadsheet ID
"Spreadsheet Tab Name" → Specify the tab name like "Sheet1"
"Table Range" → Specify the table range in the format "A1:G30"

The items set in Google Sheets will be displayed as follows, so select the appropriate output from the red frame.
Click "Test" → "Test Successful" → "Save".

Finally, by turning the app trigger "ON", the automation setup is complete.

‍

Summary

In this article, we set up an automation process to "add order information to Google Sheets when an order is created in Squarespace."
By integrating Squarespace with Google Sheets, managing order information becomes easier, which can improve work efficiency.
Additionally, you save time and effort as you no longer need to manually transfer order information to Google Sheets.
With Yoom, you can achieve automation with simple settings, making it very convenient.
If you haven't used Yoom yet or are considering it, please try it out from this free registration form!