Skip to main content
Return to top

Zapier: Importing orders via Google Sheets

Contact Person
  • Updated

Purpose: Import orders from a (shared) Google Sheets project if you need a more individual solution.

If you simply want to add orders from a CSV file we recommend our CSV import. This guide is mainly targeted towards Zapier users who would like to make use of our order import via API.

banner_free_EN.png

Prerequisites

In order to follow along, you need the following:

  1. A Zapier account: This guide also works with a trial account. There are no paid apps needed.
  2. A set up Sendcloud API connection: See here how to activate our API in your account. You don't need a paid subscription with us.
  3. Basic knowledge of how to work with an API

Google Sheets trigger

The first step of your "order import" zap will be the trigger. Go ahead and add the Google Sheets app. As the trigger event, we will choose "New Spreadsheet row" but if you prefer to trigger the event every time you add a completely new spreadsheet, you can do so as well.

mceclip0.png

Next, you will have to choose your Google account, customize your spreadsheet rows, and find data (i.e. test your Google connection). This is necessary for the trigger to understand which spreadsheet is used for the trigger so we can take data from specific cells / columns and feed them into our Sendcloud API request. 

If you run into problems setting up your Google connection, please see this guide from Zapier to troubleshoot.

Customizing the API request

To create an API request event, we will use the Webhooks by Zapier app. For the action event, choose Custom Request. 

mceclip1.png

Customize Request

In this guide, we will create a parcel via API. Customize your request as following:

Method POST
URL https://app.sendcloud.sc/api/v2/parcels
Data Pass-Through False

Data

This step is where the individuality of your request is the biggest advantage. You can use any of the parameters of our API documentation to fulfill your needs. Below, we will showcase a very simple example, where every order from the Google Sheet will be imported into the Incoming Order View in Sendcloud. The actual label creation will be done in the Sendcloud panel where you can choose your shipping method, insurance, etc. 

If you know which shipping method to use and if you would like the label to be created automatically, you can, of course, customize the payload of this request to your needs.

mceclip2.png

In order to create the label automatically, set the "request_label" parameter to true. Please check the API documentation to see which other parameters are then required.

Authentication & Header

For authentication, we will use Basic Auth. Use your public & secret key from the Sendcloud API setting, separated by a pipe ("|").

Set the Content-Type to "application/json"

mceclip3.png

And that's it!

You can now go ahead and test this zap. If you encounter any problems with the API request (i.e. the event), please don't hestitate to contact our customer service under contact@sendcloud.com. If you encounter any problems with the Google Sheets trigger, please check Zapier's troubleshooting article.