Export Orders to Spreadsheet

How to automatically send your Twice orders to Google Sheets

This guide will help you connect your Twice account to your Google Spreadsheet and automatically create new rows for each new Twice booking. This is a good starting point for further analytics or other customizations, such as custom emails for instance.

The setup will take approximately 10 minutes and you won't need any technical skills to create the connection!

On this page

Step 1: Twice - Webhook

Step 2: Google Sheets - Search Rows

Step 3: Google Sheets - Add a Row

Step 4: Google Sheets - Update a Row

Step 5: Google Sheets - Delete a Row

Step by step guide to creating the connection

After setting up your Google and Make account as outlined in the prerequisites, you should now have opened this make scenario template. Now choose create new scenario from template from the lower left side of your screen.

You only need to to some adjustments in the red webhook module, as well as the four Google Sheet modules. The adjustments to be done in the Google Sheet modules are fundamentally the same in each module.

Step 1: Twice - Webhook

1. Select add to add a webhook.
2. Give the webhook a descriptive name. For example “Orders to Sheets” and click Save.
3. Copy the newly appearing blue URL to clipboard and don't close the make.com window.
4. Open your Twice Admin, navigate to Account > Integrations to add a new Webhook and apply the following:
   1. Triggers on: Select order/updated
   2. URL: Paste the URL from your make scenario and add it
   3. Test your Webhook: Send test request and continue when successful
      When the initial test returns failed, navigate back to your make scenario and click "redetermine data structure" and retry the Test in Twice Admin
   4. Label: Give the webhook a descriptive label
5. Back in your Make scenario, select Continue

Step 2: Google Sheets - Search Rows

1. Select your Google Account

2. Select the Spreadsheet you created earlier