Get a weekly Shopify sales recap sent to Slack and stored in Google Sheets. Store owners and sales teams can see order count and revenue at a glance without logging into Shopify.

A schedule runs once a week at 10. It reads Shopify orders, captures the order date, and checks a cutoff date to include only recent orders. The flow maps each order total into a clean price field. A small function then counts all kept orders and sums their values. The results are posted to a Slack channel for quick team visibility and also written as a new row in a Google Sheet for tracking over time.

You need Shopify, Slack, and Google Sheets accounts connected in n8n. Point the Google Sheets node at your sheet and set the columns for totals. Update the date filter to cover the period you care about, such as the last seven days or this week. Once active, the team gets a clear weekly update and your sheet becomes a simple sales log. Expect to cut manual reporting from about one hour to a few minutes while keeping data in one place for reviews and planning.

• Weekly schedule using a Cron trigger set to run at 10
• Shopify get all orders to pull recent sales data
• Date and Time step maps created at into an order date field
• IF filter keeps only orders after a chosen cutoff date
• Set node maps total price into a clean orderPrice field
• Function node counts orders and sums total revenue
• Slack message posts totals to a chosen channel
• Google Sheets append writes the weekly summary as a new row
• NoOp handles non matching items for a clean branch

• Reduce weekly reporting time from 60 minutes to 5 minutes
• Streamline sales updates for the team by about 90 percent
• Cut copy and paste mistakes by up to 90 percent
• Connect Shopify, Slack, and Google Sheets in one flow
• Create a simple sales log for audits and planning

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Shopify, Google Sheets and Slack. See the Tools Required section above for links to create accounts with these services.
3. Open the Cron node and confirm it runs every week at the time you want. Set the correct timezone in n8n so the run happens at your local time.
4. Double click the Shopify node. In the Credential to connect with menu, click Create new credential and follow the on screen steps to connect your Shopify store. Make sure the node is set to get all orders.
5. In the Shopify node, verify that created_at and total_price fields are returned. If needed, adjust the fields or filters so the data includes these values.
6. Check the Date and Time node. It should read the created_at value and store it in order_date. Leave the data property name as order_date.
7. Open the IF node. Update the comparison date to match your reporting window, such as the start of the current week or a date expression for the last seven days.
8. Open the Set node. Confirm orderPrice maps to the total_price field and that Keep only set is enabled to simplify the data for the sum.
9. Open the Google Sheets node. In the credential dropdown, click Create new credential and complete OAuth2 for Google Sheets. Paste your sheet ID, pick the correct sheet tab, and add columns for totalOrders and ordersSum.
10. Open the Slack node. In the credential dropdown, click Create new credential and authorize your Slack workspace. Choose the channel where you want the weekly message to post.
11. Run the workflow once manually to test. Check Slack for the message and verify a new row appears in Google Sheets with the totals.
12. If totals look wrong, check the IF node date filter and the Set node mapping. If Google Sheets fails, confirm the sheet ID and that your account has edit access. If Slack fails, verify the bot has permission to post to the channel.
13. Turn on the workflow. Monitor the next scheduled run and confirm the message time matches your timezone settings.