Automate Weekly YouTube Reports with Google Sheets & Gmail

Automate Your Weekly YouTube Reports with Efficiency Using Google Sheets & Gmail

Streamline your YouTube reporting process and save valuable time each week with our powerful n8n workflow: Automate Weekly YouTube Reports with Google Sheets & Gmail. This robust automation pulls client data from Google Sheets, leverages the StopHy API to fetch essential YouTube channel statistics, and delivers personalized reports directly to your clients’ inboxes via Gmail. Say goodbye to manual reporting tasks and hello to seamless automation.

What this workflow does

• Manual Trigger Execution: Simply click ‘Execute workflow’ to kickstart the reporting process.
• Read Client Data: Retrieves all client information, including email addresses and YouTube channel URLs, from a designated Google Sheets spreadsheet.
• Fetch YouTube Metrics: Utilizes the StopHy channel API to gather channel metrics and the latest video statistics for each client.
• Report Formatting: Organizes data into comprehensive reports detailing subscriber counts, total videos, and specific metrics about the most recent video.
• Personalized Email Reporting: Sends detailed, individualized reports to clients through Gmail, ensuring each client receives relevant insights.
• Run Log Summarization: Adds an overview of each report run, including client names and channel statistics, to a separate Google Sheets log for record-keeping.

Use cases

• Freelance Social Media Managers: Effortlessly deliver weekly YouTube performance reports to clients without manual data aggregation and analysis.
• Digital Marketing Agencies: Automate regular report generation for multiple YouTube accounts, enhancing productivity and client satisfaction.
• SaaS Operators: Provide stakeholders with up-to-date YouTube performance insights, ensuring timely decision-making backed by precise data.

Technical details

• Nodes Used: Set, Gmail, HTTP Request, Google Sheets, Manual Trigger, Split In Batches
• Integrations: StopHy API for channel metrics, Google Sheets for data storage and logging, Gmail for email communications
• Authentication Required: Google Sheets OAuth2 and Gmail OAuth2 credentials setup needed for seamless operations.
• Endpoint Utilization: Access to StopHy API endpoint (https://api.stophy.dev/v1/channel) is mandatory for retrieving YouTube metrics.