Apply on
You are managing a system where multiple teams
(e.g., Marketing, Sales, HR, and Operations)
Maintain separate Google Sheets for tracking their respective data. Each team updates their sheets daily. You aim to create a centralized Google Sheet that automatically fetches data from these individual team sheets, applies data transformations, and generates summary reports.
Requirements:
—---------------------------------------
We are seeking a skilled Automation Specialist to manage and optimize automation processes across Google Sheets and key paid advertising platforms, including Google Ads, Meta Ads, and Bing Ads dashboards.
Key Responsibilities:
Develop and maintain automation scripts for data integration and reporting.
Optimize workflows in Google Sheets for improved efficiency.
Set up and automate analytics tracking for paid ad campaigns.
Collaborate with teams to streamline reporting across ad platforms.
Ideal Candidate:
Strong experience with automation tools and scripting (e.g., Apps Script, Python).
Proficiency in managing dashboards for Google Ads, Meta Ads, and Bing Ads.
Analytical mindset with a focus on efficiency and performance.
Data Consolidation:
Automate the pulling of data from multiple team-specific Google Sheets into a master sheet using Google Apps Script.
Ensure the data updates automatically on a schedule (e.g., every day at 9 AM).
Handle cases where one or more team sheets are temporarily unavailable.
Data Transformation:
After consolidating the data, write a script that performs the following transformations:
Filter rows based on specific criteria (e.g., only include rows where the status is "Completed").
Add calculated fields (e.g., calculate the total sales from Sales data or average task completion time from HR data).
Error Handling and Logging:
Implement error handling to log any issues (e.g., missing data, script errors) into a separate "Error Log" sheet.
Include meaningful error messages for troubleshooting.
Dynamic Reporting:
Generate summary reports in the master sheet, such as:
Total Sales by region (from Sales data).
Percentage of completed tasks (from HR data).
Weekly trends or charts (from Marketing data).
Use Apps Script to create and update these reports dynamically.
User-Friendly Dashboard:
Build a dashboard in the master sheet that displays real-time insights from the consolidated data.
Include slicers or dropdown filters for users to view specific subsets of the data.
Advanced Features:
Allow tea m me mbers to trigger manual updates via a custo m me nu in Google Sheets.
Add email notifications for specific events, such as when a sheet fails to update or certain thresholds (e.g., sales drop by 10%) are met.
Evaluation Criteria:
Technical Proficiency: Assess their ability to write clean, efficient, and maintainable Google Apps Script code.
Problem-Solving: Evaluate how they handle complex data transformations and error scenarios.
Creativity: See how they design the dashboard and provide actionable insights.
Communication: Ask them to explain their approach, code structure, and decisions made during the task.
Loom Video Link for better Understanding:
https://www.loom.com/share/ccb95da4e0514ab291dc00226f4499e4
