How to export order data to a spreadsheet

This guide explains how to automatically export your Buunto order data (delivery/pickup dates, time slots, and methods) to an external spreadsheet such as Excel on OneDrive or Google Sheets.

Buunto does not modify your Shopify shipping settings. All the approaches below only read the date/time data that Buunto attaches to your orders.

Option 1 - Via Google Calendar

If you already have Buunto's automatic export to Google Calendar enabled, you can use an automation tool to sync those calendar events to a spreadsheet.

Using Google Sheets

You can connect Google Calendar to Google Sheets using any of these approaches:

• Google Apps Script - In Google Sheets, go to Extensions > Apps Script and use the built-in Google Calendar API to pull events from the calendar linked to Buunto
• Make.com or Zapier - Create an automation with the trigger "New event in Google Calendar" and the action "Add a row to Google Sheets"

Using Excel on OneDrive

If you use Microsoft 365, you can connect Google Calendar to Excel using Power Automate:

1. Create a new automated flow
2. Set the trigger to "When a new event is created in Google Calendar"
3. Select the calendar linked to Buunto (e.g. "Shop Orders")
4. Add the action "Add a row into a table" and select your OneDrive Excel file
5. Map the calendar event fields (subject, start time, end time, location) to your spreadsheet columns

You can also use Make.com or Zapier as an alternative to Power Automate.

Option 2 - Via Shopify Flow and order notes

Buunto can append the chosen method, date, and time slot to the Shopify order notes field. Shopify Flow can read order notes, allowing you to forward this data to an external service.

Step 1 - Enable the required settings in Buunto

In the Buunto app, go to Settings > Advanced Settings and enable the following two options in this order:

1. "Only allow one selection (delivery method / date / time slot) per order" - this must be enabled first
2. "Append the chosen method/date/time slots to the order's notes"

Once enabled, every new order will include the Buunto data in the order notes field.

Step 2 - Create a Shopify Flow workflow

1. In Shopify, go to Settings > Flow and create a new workflow
2. Set the trigger to "Order created"
3. Add an action "Send HTTP request" pointing to a webhook URL from your automation tool (Power Automate, Make.com, or Zapier)
4. Include the order notes in the request body using the {{ order.note }}  variable

Step 3 - Connect to your spreadsheet

In your automation tool, set up the receiving webhook to parse the order note and add a row to your spreadsheet with the relevant fields.

Which option should I choose?

If you already have the Google Calendar export enabled, Option 1 is the quickest path. If you prefer to keep everything within Shopify's ecosystem, Option 2 gives you more control over the workflow.