Tired of searching for a way to save new ShipStation orders to Google Sheets?

How to Save New ShipStation Orders to Google Sheets

If yes, then here you can sit back and relax as we are going to integrate ShipStation with Google Sheets in real-time. However, several times people want their orders to auto-populate in Google Sheets. And in such a hectic life, saving every single new ShipStation orders to Google Sheets manually is a hell lot of work to do. This is where apps like Pabbly Connect comes into play.

Using this, you can create smooth workflows, and save yourself from boring or repeated work. Moreover, to use this app, you don’t even require to have any technical skills.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect   

In just a few minutes, you will be able to integrate ShipStation with Google Sheets using Pabbly Connect in real-time.

Moreover, this software is packed with many features like routers, path-routers, instant triggers, and many more even in its free plan.

So, without wasting any of your time, let’s get started.

Step 1: Sign up to Pabbly Connect

Sign Up

Begin the process of connecting ShipStation to Google Sheets by clicking on the “Sign Up Free” icon on the Pabbly Connect dashboard. Further, either fill-up the details manually or else you can sign up via Gmail account.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

Following that, after logging into the account, press on the “Access Now” button as shown in the above image.

Step 3: Workflow for ShipStation & Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Begin the process of building a workflow for integration by pressing on the “Create New Workflow” button.

(b) Name the Workflow

Name the Workflow

Furthermore, add the name of workflow which in our case is “ShipStation to Google Sheets”. Although, you can always name the workflow as per your requirements.

Step 4: Setting Trigger for ShipStation to Google Sheets Integration

Subsequently, after building a workflow, you have to select the integration app to make a ShipStation order. Pabbly Connect allows you to build unlimited workflows within minutes, tap here to sign up for unlimited workflows for free.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate

The next step is to select “ShipStation” from the dropdown, then choose the “New Order” option to save the data from the software into Google Sheets.

(b) Click on the Connect Button

Click on the Connect Button

The subsequent step is to click on the “Connect With ShipStation” button which is appearing on the dashboard.

Step 5: Connecting ShipStation to Pabbly Connect

(a) Click on the Settings Link

Click on the Settings Link

Once you click on the connect button, a side panel will open up asking for the API Key and API Secret Key. And in order to get those keys, you need to click on the “Settings” link appearing in the corner.

(b) Copy the API Keys

Copy the API Keys

Now, the next thing is to copy the API Key along with the API Secret Key to paste in the Pabbly Connect dashboard.

(c) Paste the API Keys

Paste the API Keys

Now, paste the keys in their respective given columns. After that, just click on the “Save” button given below.

Step 6: Create a New Order in ShipStation

Subsequently, in order to save the new ShipStation order in Google Sheets, you need to make an entry of the order. Hence to do that, you need to log into your ShipStation account.

(a) Click on Orders

$curr_post_title

First of all, simply click on the “Orders” to go to the orders section.

(b) Go to New Order

Go to New Orders

Now, in order to generate a new order, you need to click on the button named “New Order”.

(c) Fillup the Order Details

Fill the Order Details

After that, fillup all the order details to move forward.

(d) Click on Save Order

Click on Save

Furthermore, once you are done filling the entire order details, just hit the “Save Order” button to save the order. But, before clicking on the save button, go to the Pabbly Connect dashboard and press the “Save & Send Test Request” button.

Step 7: Test the Response in Pabbly Connect Dashboard

Test the Response in Pabbly Connect Dashboard to Save New ShipStation Orders to Google Sheets

After filling up the order details, the order entry will appear on the “Pabbly Connect” dashboard. Next, press the “Save” option.

Step 8: Setting Action for ShipStation & Google Sheets Integration

Consequently, in order to make this ShipStation and Google Sheets integration work, you have to choose the action for your trigger.

(a) Select Application you Want to Integrate

Select Application you Want to Integrate to Save New ShipStation Orders to Google Sheets

Further, click on the “+” icon then select “Google Sheets” and in the choose method option, select ” Add New Row”. After that, you need to click on the button named “Connect” to authorize it with Google account.

(b) Click the Connect Button

Click the Connect Button to Save New ShipStation Orders to Google Sheets

Once you press the “Connected with Google Sheets” button, it will open the authorization window, for which you have to log in to your Google account.

(c) Map Field Data

Map Field Data to Save New ShipStation Orders to Google Sheets

All the sheets in your account will appear on the dropdown. Simply select the sheet, which in our case is “Sheet1”. Now, all you have to do is add the necessary field. Later, just click on the button named “Save & Send Test Request”.

(d) Test the Submission and Save

Test the Submission and Save to Save New ShipStation Orders to Google Sheets

Subsequently, once you hit the “Send Test Request”, all the entries will be sent to Google Sheets Rows. Just click on the “Save” button to save the entire workflow.

Step 9: Check Response in Google Sheets

Check Response in Google Sheet to Save New ShipStation Orders to Google Sheets

Finally, when you check the Google Sheets, the entered details get auto-populated in a sheet. This is a one-time process, after this whenever a new order is saved in the ShipStation account, it will get auto-populated in the Google Sheets rows.

Conclusion –

Hopefully, Now you know how to save new ShipStation Orders to Google Sheets. All you have to do is follow all the above-mentioned steps and you can connect ShipStation to Google Sheets quickly. One can easily avoid repetitive work with the help of automation by using software like Pabbly Connect which allows unlimited premium applications.

So, wait no longer. Go and get your access by signing up for a free account.

You May Also Like To Read –