Purpose: Import orders from a (shared) Google Sheets project if you need a more individual solution.
In order to follow along, you need the following:
- A Zapier account: This guide also works with a trial account. There are no paid apps needed.
- 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.
- 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.
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.
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.
In this guide, we will create a parcel via API. Customize your request as following:
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.
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"
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 firstname.lastname@example.org. If you encounter any problems with the Google Sheets trigger, please check Zapier's troubleshooting article.