Store Count Automation

Generate and email active and inactive store list daily via BigQuery.

Integrations Used

About

This workflow automates the process of generating a list of active and inactive stores using a BigQuery query and sends the list via email. It is ideal for retail companies such as Hamleys to keep track of their store operations daily. The workflow is scheduled to run every day at 4:30 AM, ensuring that the team is updated with the latest store status. This automation reduces manual efforts in data extraction and communication, enhancing efficiency in store management operations.

How to use this template

Ensure that you have access to the BigQuery service with the necessary permissions to query the required database.
Set up the workflow by configuring the desired email recipients in the Gmail activity.
The workflow is triggered automatically every day at 4:30 AM using a cron schedule.
The query results are stored and converted into a CSV file, which is then uploaded for sharing.
An email is sent to the specified recipients with the CSV attached and a download link provided.

FAQs

What if I want to modify the schedule?

You can change the cron expression in the trigger configuration to adjust the schedule.

Can I add more email recipients?

Yes, modify the 'to' field in the Gmail activity to include additional email addresses.

Similar Templates

View all

Workflow

Copilot.Live AI Tools

Used by 1k

Use this Boltic workflow template to orchestrate Copilot.Live AI actions with webhook triggers, dynamic branching, and tool-based execution—no code required.

automationworkflow+5

Workflow

Automate Outreach and Lead Nurturing

Used by 1k

Automate lead nurturing through Slack and email with GPT integration.

automatelead nurturing+5

Workflow

Market Research And Business Case Generator

Used by 1k

Automates market research and business case generation via email.

market researchbusiness case+4