Store Count Automation

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

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

Market Research And Business Case Generator

Used by 1k

Automates market research and business case generation via email.

market researchbusiness case+4

Workflow

URL Index Check via Google Search Engine

Used by 1k

Check URL indexing on Google and report via Slack.

urlindexing+5

Workflow

Resume Analysis

Used by 1k

Automates resume analysis and sends evaluation scores via email.

resume analysisemail automation+3