Weekly Shopify Sales Summary

This n8n workflow automates the process of summarizing weekly Shopify sales data and storing it in a Google Sheet with alert notifications for errors. It begins with a webhook trigger that receives data, which is then split into manageable chunks for processing. The data is embedded using Cohere, stored in Pinecone, and indexed for similarity searches. A Langchain RAG (Retrieval-Augmented Generation) agent uses this indexed data to generate a natural language summary. The summary is appended to a Google Sheet, providing a historical log. If any errors occur during the process, a Slack notification is sent to alert the team.

This workflow is ideal for eCommerce managers or teams who want to streamline weekly sales reporting, simplify data storage and retrieval, and receive immediate alerts for workflow issues, ensuring timely insights and operational efficiency.