⭠ all tutorials

Automated sales reporting for Shopify with Integromat

Available for Unlimited All Access members only

Get access

In this tutorial I'll show you how to build out automated sales reporting for your Shopify Store.

What you'll need.

  • 1 x Shopify Store
  • 1 x Integromat Account
  • 1 x Google Sheet
  • 1 x Twillio Account

The full tutorial is available for pro members only

Request access

First up, open Google Sheets and add the the following headers onto your sheet.

  • Order Number
  • Email
  • Shipping Address
  • City Phone
  • Country
  • Code
  • Zip / Postcode
  • Month
  • Week
  • Daily Total
  • Weekly Total
  • Monthly Total
  • Todays Date
  • This Week
  • This Month

Next add some dummy data into the first batch of columns which will simulate orders that will come in from Shopify.

Once done move on to the next part.

For this part we're going to add in some formulas to total up order values by day, week and month.

In the cell R2 enter '=TODAY()' to get todays date.

Next in cell N2, enter '=SUMIF(A:A,R2,B:B), this will give us the daily order value total.

Now in cell S2, enter '=WEEKNUM(R2)', this will give us the week number.

In cell T2 enter, '=MONTH(R2)' for the month of the year.

Next let's total the weekly amount by entering '=SUMIF(L:L,S2,B:B)'.

Now enter '=SUMIF(K:K,T2,B:B) to get the total for the month.

Once you've done this move onto the next step.

In this part let's add some formulas that will let us get values in the weekly and months totals.

In cell L2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", WEEKNUM(A2)))'. This should now give you a number which relates to the week of the year currently.

Next in cell K2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", MONTH(A2)))'. Now we have our month.

Note this will only display if there is order data containing a date in the A column.

When you're done you're ready to move onto the next step.

Open Integromat.

Create a Scenario and type Shopify and Google Sheets into the search bar. Press continue.

Now on your canvas click the ? and add Shopify. Connect your Shopify account and configure.

Now  add another module which is going to be Google Sheets. Connect your account and find the right worksheet.

Next map the Order Value, Order ID, Order Number, Email, Shipping Address, City, Phone, Country Code and Zip into the relevant fields.

Press ok.

Now in the Date field, let's format the date by clicking the Date and Time module in the blue pop up menu. Click the formatDate element.

Enter the Created At field in the first half of the brackets and then 'DD/MM/YYYY" in the second.

Press ok and test.

Now onto the next step.

In Integromat, go back to the dashboard and create a new Scenario.

Add the Google Sheet module 'Get a Cell' and connect your sheet + cell N2 that related to our Daily Total.

Next add Twilio as the second module and link them together. If you are adding Twilio for the first time you will need to add your credentials.

Now inside of the Twilio module select Send a Message.

It should pull in your Twilio phone number in the Sender Number field. In the Recipient Number enter your own mobile number for testing.

In the message enter your report information containing the daily order value making sure you contain the value from the Get a Cell step.

Test it and check the SMS arrives.

Next click the Schedule Setting in the bottom left. Set it to a time of your choosing.

Set it live.

Add additional notification channels like Gmail or Slack now you know how to add modules.

That's it!

If you would like to send the weekly and monthly values in your Daily Report then add two more Get a Cell modules in.

Configure the modules to look at the corresponding cells inside your Google Sheet.

Amend your report to reflect the new values.

All done.

I hope you enjoyed this tutorial and let me know if you have any issues.

Tom Osman

@tomosman on Twitter

In this tutorial I'll show you how to build out automated sales reporting for your Shopify Store.

What you'll need.

  • 1 x Shopify Store
  • 1 x Integromat Account
  • 1 x Google Sheet
  • 1 x Twillio Account

First up, open Google Sheets and add the the following headers onto your sheet.

  • Order Number
  • Email
  • Shipping Address
  • City Phone
  • Country
  • Code
  • Zip / Postcode
  • Month
  • Week
  • Daily Total
  • Weekly Total
  • Monthly Total
  • Todays Date
  • This Week
  • This Month

Next add some dummy data into the first batch of columns which will simulate orders that will come in from Shopify.

Once done move on to the next part.

For this part we're going to add in some formulas to total up order values by day, week and month.

In the cell R2 enter '=TODAY()' to get todays date.

Next in cell N2, enter '=SUMIF(A:A,R2,B:B), this will give us the daily order value total.

Now in cell S2, enter '=WEEKNUM(R2)', this will give us the week number.

In cell T2 enter, '=MONTH(R2)' for the month of the year.

Next let's total the weekly amount by entering '=SUMIF(L:L,S2,B:B)'.

Now enter '=SUMIF(K:K,T2,B:B) to get the total for the month.

Once you've done this move onto the next step.

In this part let's add some formulas that will let us get values in the weekly and months totals.

In cell L2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", WEEKNUM(A2)))'. This should now give you a number which relates to the week of the year currently.

Next in cell K2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", MONTH(A2)))'. Now we have our month.

Note this will only display if there is order data containing a date in the A column.

When you're done you're ready to move onto the next step.

Open Integromat.

Create a Scenario and type Shopify and Google Sheets into the search bar. Press continue.

Now on your canvas click the ? and add Shopify. Connect your Shopify account and configure.

Now  add another module which is going to be Google Sheets. Connect your account and find the right worksheet.

Next map the Order Value, Order ID, Order Number, Email, Shipping Address, City, Phone, Country Code and Zip into the relevant fields.

Press ok.

Now in the Date field, let's format the date by clicking the Date and Time module in the blue pop up menu. Click the formatDate element.

Enter the Created At field in the first half of the brackets and then 'DD/MM/YYYY" in the second.

Press ok and test.

Now onto the next step.

In Integromat, go back to the dashboard and create a new Scenario.

Add the Google Sheet module 'Get a Cell' and connect your sheet + cell N2 that related to our Daily Total.

Next add Twilio as the second module and link them together. If you are adding Twilio for the first time you will need to add your credentials.

Now inside of the Twilio module select Send a Message.

It should pull in your Twilio phone number in the Sender Number field. In the Recipient Number enter your own mobile number for testing.

In the message enter your report information containing the daily order value making sure you contain the value from the Get a Cell step.

Test it and check the SMS arrives.

Next click the Schedule Setting in the bottom left. Set it to a time of your choosing.

Set it live.

Add additional notification channels like Gmail or Slack now you know how to add modules.

That's it!

If you would like to send the weekly and monthly values in your Daily Report then add two more Get a Cell modules in.

Configure the modules to look at the corresponding cells inside your Google Sheet.

Amend your report to reflect the new values.

All done.

I hope you enjoyed this tutorial and let me know if you have any issues.

Tom Osman

@tomosman on Twitter

In this tutorial I'll show you how to build out automated sales reporting for your Shopify Store.

What you'll need.

  • 1 x Shopify Store
  • 1 x Integromat Account
  • 1 x Google Sheet
  • 1 x Twillio Account

First up, open Google Sheets and add the the following headers onto your sheet.

  • Order Number
  • Email
  • Shipping Address
  • City Phone
  • Country
  • Code
  • Zip / Postcode
  • Month
  • Week
  • Daily Total
  • Weekly Total
  • Monthly Total
  • Todays Date
  • This Week
  • This Month

Next add some dummy data into the first batch of columns which will simulate orders that will come in from Shopify.

Once done move on to the next part.

For this part we're going to add in some formulas to total up order values by day, week and month.

In the cell R2 enter '=TODAY()' to get todays date.

Next in cell N2, enter '=SUMIF(A:A,R2,B:B), this will give us the daily order value total.

Now in cell S2, enter '=WEEKNUM(R2)', this will give us the week number.

In cell T2 enter, '=MONTH(R2)' for the month of the year.

Next let's total the weekly amount by entering '=SUMIF(L:L,S2,B:B)'.

Now enter '=SUMIF(K:K,T2,B:B) to get the total for the month.

Once you've done this move onto the next step.

In this part let's add some formulas that will let us get values in the weekly and months totals.

In cell L2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", WEEKNUM(A2)))'. This should now give you a number which relates to the week of the year currently.

Next in cell K2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", MONTH(A2)))'. Now we have our month.

Note this will only display if there is order data containing a date in the A column.

When you're done you're ready to move onto the next step.

Open Integromat.

Create a Scenario and type Shopify and Google Sheets into the search bar. Press continue.

Now on your canvas click the ? and add Shopify. Connect your Shopify account and configure.

Now  add another module which is going to be Google Sheets. Connect your account and find the right worksheet.

Next map the Order Value, Order ID, Order Number, Email, Shipping Address, City, Phone, Country Code and Zip into the relevant fields.

Press ok.

Now in the Date field, let's format the date by clicking the Date and Time module in the blue pop up menu. Click the formatDate element.

Enter the Created At field in the first half of the brackets and then 'DD/MM/YYYY" in the second.

Press ok and test.

Now onto the next step.

In Integromat, go back to the dashboard and create a new Scenario.

Add the Google Sheet module 'Get a Cell' and connect your sheet + cell N2 that related to our Daily Total.

Next add Twilio as the second module and link them together. If you are adding Twilio for the first time you will need to add your credentials.

Now inside of the Twilio module select Send a Message.

It should pull in your Twilio phone number in the Sender Number field. In the Recipient Number enter your own mobile number for testing.

In the message enter your report information containing the daily order value making sure you contain the value from the Get a Cell step.

Test it and check the SMS arrives.

Next click the Schedule Setting in the bottom left. Set it to a time of your choosing.

Set it live.

Add additional notification channels like Gmail or Slack now you know how to add modules.

That's it!

If you would like to send the weekly and monthly values in your Daily Report then add two more Get a Cell modules in.

Configure the modules to look at the corresponding cells inside your Google Sheet.

Amend your report to reflect the new values.

All done.

I hope you enjoyed this tutorial and let me know if you have any issues.

Tom Osman

@tomosman on Twitter

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

First up, open Google Sheets and add the the following headers onto your sheet.

  • Order Number
  • Email
  • Shipping Address
  • City Phone
  • Country
  • Code
  • Zip / Postcode
  • Month
  • Week
  • Daily Total
  • Weekly Total
  • Monthly Total
  • Todays Date
  • This Week
  • This Month

Next add some dummy data into the first batch of columns which will simulate orders that will come in from Shopify.

Once done move on to the next part.

For this part we're going to add in some formulas to total up order values by day, week and month.

In the cell R2 enter '=TODAY()' to get todays date.

Next in cell N2, enter '=SUMIF(A:A,R2,B:B), this will give us the daily order value total.

Now in cell S2, enter '=WEEKNUM(R2)', this will give us the week number.

In cell T2 enter, '=MONTH(R2)' for the month of the year.

Next let's total the weekly amount by entering '=SUMIF(L:L,S2,B:B)'.

Now enter '=SUMIF(K:K,T2,B:B) to get the total for the month.

Once you've done this move onto the next step.

In this part let's add some formulas that will let us get values in the weekly and months totals.

In cell L2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", WEEKNUM(A2)))'. This should now give you a number which relates to the week of the year currently.

Next in cell K2, enter '=ARRAYFORMULA(IF(ISBLANK(A2), " ", MONTH(A2)))'. Now we have our month.

Note this will only display if there is order data containing a date in the A column.

When you're done you're ready to move onto the next step.

Open Integromat.

Create a Scenario and type Shopify and Google Sheets into the search bar. Press continue.

Now on your canvas click the ? and add Shopify. Connect your Shopify account and configure.

Now  add another module which is going to be Google Sheets. Connect your account and find the right worksheet.

Next map the Order Value, Order ID, Order Number, Email, Shipping Address, City, Phone, Country Code and Zip into the relevant fields.

Press ok.

Now in the Date field, let's format the date by clicking the Date and Time module in the blue pop up menu. Click the formatDate element.

Enter the Created At field in the first half of the brackets and then 'DD/MM/YYYY" in the second.

Press ok and test.

Now onto the next step.

In Integromat, go back to the dashboard and create a new Scenario.

Add the Google Sheet module 'Get a Cell' and connect your sheet + cell N2 that related to our Daily Total.

Next add Twilio as the second module and link them together. If you are adding Twilio for the first time you will need to add your credentials.

Now inside of the Twilio module select Send a Message.

It should pull in your Twilio phone number in the Sender Number field. In the Recipient Number enter your own mobile number for testing.

In the message enter your report information containing the daily order value making sure you contain the value from the Get a Cell step.

Test it and check the SMS arrives.

Next click the Schedule Setting in the bottom left. Set it to a time of your choosing.

Set it live.

Add additional notification channels like Gmail or Slack now you know how to add modules.

That's it!

If you would like to send the weekly and monthly values in your Daily Report then add two more Get a Cell modules in.

Configure the modules to look at the corresponding cells inside your Google Sheet.

Amend your report to reflect the new values.

All done.

I hope you enjoyed this tutorial and let me know if you have any issues.

Tom Osman

@tomosman on Twitter

Get help and discuss

Open community forum

Related lessons

Selling digital products with Gumroad with Notion & Super
Develop a custom CRM using Retool and 8base
Send emails from Zapier and get analytics with Palabra
Generate a task list for projects in Airtable
Generate pre-filled contracts in Hubspot using PandaDoc
Sync files across Airtable, Hubspot, and Google Drive
Pre-Fill Airtable forms and link forms to existing records
Automate recurring interactions in your deal & project cycle
Connect Hubspot Deals to Airtable
Working with GraphQL queries in the API Explorer - 8base
Defining data tables and relationships in the data builder - 8base
Automate scheduling meetings, calendar invites, and CRM admin work
Sales automation workflow using Typeform / Airtable / Callingly
Introduction and overview of Universe
Capture email metadata and save as an image with Zapier
Find & save competitor info and emails with Hunter
Email outreach & sequencing with Reply.io & Gmail
Source Leads from a Spreadsheet with Dashdash
Create an About Me page on Universe
Create an eCommerce Store on Universe
Slack App That Scrapes Websites for Data
How to Easily Scrape Websites for Data using Autocode
Send a personalized download link with YAMM
Create a targeted sales list in dashdash
Airtable - the basics
Rank blog posts in Webflow by pageviews
Auto-accept LinkedIn invites
Dynamically generate Google Slides
Automate + qualify your lead generation with Standard Library
Generate and send contracts automatically with PandaDoc
Automated Airtable sales notifications in Zapier
Create a sales pipeline in Airtable
Get data from an API with Parabola + Google Sheets
A calculator app in Boundless
Simple eCommerce mobile app with Glide
Automatically create a new product in Shopify
Pull LinkedIn Company info & create a new record in Webflow
Monitor and save posts from Reddit
Fulfil Shopify orders automatically
How to create an automated Google Sheets dashboard
Build a GOAT App style marketplace in 30 minutes
Build a Mail Merge with Airtable, Gmail, and Standard Library.
Physical Product Subscriptions with Gumroad + Carrd
Build a Slack / Airtable / Stripe CRM
Selling digital goods with Carrd + Gumroad
From Coinmartketcap to Google Sheets without any code
Update salesforce opportunities with computed data
How to automatically feed data to google sheets
Export data from MySQL into a CSV in Google Sheets
Automatically get data from Mailchimp to your CRM
Sales CRM - build a sales pipeline
Fundraising CRM - Startups seeking to raise funding
👨‍👩‍👧‍👦Personal CRM - keep track of people in your life
Segmenting prospects for sales funnels
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.