Google Sheets & E-commerce Data Specialist
Budget: $8 – $15 USD
? Job Overview:
We are looking for a highly skilled Google Sheets, Data Automation, and Social Media Analytics Specialist to assist in developing spreadsheet-driven forecasting, demand planning, inventory tracking, social media performance tracking, and financial analysis tools for our e-commerce business. The ideal candidate should be proficient in Google Sheets, Make.com (formerly Integromat), API integrations, and e-commerce data analysis (Shopify, Stripe, etc.).
You will work on a case-by-case basis to build tools that help us make data-driven decisions regarding inventory, financials, fulfillment, social media marketing, and customer analytics. This role will also include supporting tasks currently handled by our Virtual Assistant, ensuring seamless integration of data management, customer service, marketing performance tracking, and operational workflow.
? Key Responsibilities:
✅ Google Sheets Development: Design automated dashboards for business insights✅ Shopify & Make.com Automation: Sync Shopify data to Google Sheets using Make.com✅ Demand Forecasting: Build SKU-specific demand forecasting models✅ Inventory & Supply Chain Tracking: Automate stock tracking for both raw materials & finished goods✅ Financial & Profitability Analysis: Track fixed/variable costs, discounts, shipping profitability, and payment gateway performance✅ Customer Insights & Demographics: Analyze order trends, geographic sales, and repeat customers✅ Error Handling & Troubleshooting: Identify and correct data discrepancies✅ Customer Service Data Integration: Assist in managing customer inquiries, tracking refunds, and organizing order follow-ups✅ Administrative & Operations Support: Help with managing daily reports, updating spreadsheets, and organizing supplier communications✅ Marketing & Ad Data Analysis: Provide insights into top-performing products, ad spend efficiency, and geographic targeting for campaigns✅ Social Media Management & Analytics: Track and report on social media performance, engagement rates, follower growth, and ad ROI✅ Content & Ad Creative Coordination: Assist in creating, organizing, and optimizing ad creatives for digital marketing campaigns✅ Web Development & Email Marketing Support: Help in basic website updates, email campaign execution, and tracking performance analytics✅ Inbox & Task Organization: Assist in managing and organizing business and customer emails for better workflow efficiency
? Requirements & Qualifications:
✔️ Expert in Google Sheets / Excel (advanced formulas, pivot tables, conditional formatting, scripting)✔️ Experience with Shopify API, Make.com, and Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Experience with social media analytics & performance tracking✔️ Familiarity with email marketing automation and reporting✔️ Bonus: Knowledge of SQL, Google Apps Script, or Python for automation
? Preferred Qualifications:
➤ Experience working with Shopify stores, e-commerce brands, or inventory-based businesses➤ Understanding of fulfillment strategies & ad targeting➤ Familiarity with geographic & demographic analytics➤ Previous experience assisting with customer service workflows & supplier coordination➤ Experience in social media content planning & analytics tracking
? Compensation & Work Arrangement:
✔️ Project-based or hourly rate (based on experience)✔️ Remote Position – Open to global talent (Preferred: Philippines)✔️ Flexible Hours – Work independently with defined project deadlines
The primary focus is on automating data processes for inventory tracking, demand forecasting, financial analysis, and customer insights. The project will primarily focus on integrating and analyzing data from Shopify. The initial project phase will focus on developing SKU-specific demand forecasting models. The initial focus will be on creating an automated inventory and supply chain tracking system to monitor stock levels and ensure timely restocks.
The project is expected to span a medium-term timeline of 3-6 months. Please communicate project updates via Slack. The specialist will have full access to our Shopify, Google Sheets, and Make.com platforms. The dashboards should include detailed data, drill-down capabilities, and extensive filtering options. The highest priority of the project is automating the inventory and supply chain tracking system to ensure timely restocks.
We are looking for a highly skilled Google Sheets, Data Automation, and Social Media Analytics Specialist to assist in developing spreadsheet-driven forecasting, demand planning, inventory tracking, social media performance tracking, and financial analysis tools for our e-commerce business. The ideal candidate should be proficient in Google Sheets, Make.com (formerly Integromat), API integrations, and e-commerce data analysis (Shopify, Stripe, etc.).
You will work on a case-by-case basis to build tools that help us make data-driven decisions regarding inventory, financials, fulfillment, social media marketing, and customer analytics. This role will also include supporting tasks currently handled by our Virtual Assistant, ensuring seamless integration of data management, customer service, marketing performance tracking, and operational workflow.
? Key Responsibilities:
✅ Google Sheets Development: Design automated dashboards for business insights✅ Shopify & Make.com Automation: Sync Shopify data to Google Sheets using Make.com✅ Demand Forecasting: Build SKU-specific demand forecasting models✅ Inventory & Supply Chain Tracking: Automate stock tracking for both raw materials & finished goods✅ Financial & Profitability Analysis: Track fixed/variable costs, discounts, shipping profitability, and payment gateway performance✅ Customer Insights & Demographics: Analyze order trends, geographic sales, and repeat customers✅ Error Handling & Troubleshooting: Identify and correct data discrepancies✅ Customer Service Data Integration: Assist in managing customer inquiries, tracking refunds, and organizing order follow-ups✅ Administrative & Operations Support: Help with managing daily reports, updating spreadsheets, and organizing supplier communications✅ Marketing & Ad Data Analysis: Provide insights into top-performing products, ad spend efficiency, and geographic targeting for campaigns✅ Social Media Management & Analytics: Track and report on social media performance, engagement rates, follower growth, and ad ROI✅ Content & Ad Creative Coordination: Assist in creating, organizing, and optimizing ad creatives for digital marketing campaigns✅ Web Development & Email Marketing Support: Help in basic website updates, email campaign execution, and tracking performance analytics✅ Inbox & Task Organization: Assist in managing and organizing business and customer emails for better workflow efficiency
? Requirements & Qualifications:
✔️ Expert in Google Sheets / Excel (advanced formulas, pivot tables, conditional formatting, scripting)✔️ Experience with Shopify API, Make.com, and Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Experience with social media analytics & performance tracking✔️ Familiarity with email marketing automation and reporting✔️ Bonus: Knowledge of SQL, Google Apps Script, or Python for automation
? Preferred Qualifications:
➤ Experience working with Shopify stores, e-commerce brands, or inventory-based businesses➤ Understanding of fulfillment strategies & ad targeting➤ Familiarity with geographic & demographic analytics➤ Previous experience assisting with customer service workflows & supplier coordination➤ Experience in social media content planning & analytics tracking
? Compensation & Work Arrangement:
✔️ Project-based or hourly rate (based on experience)✔️ Remote Position – Open to global talent (Preferred: Philippines)✔️ Flexible Hours – Work independently with defined project deadlines
The primary focus is on automating data processes for inventory tracking, demand forecasting, financial analysis, and customer insights. The project will primarily focus on integrating and analyzing data from Shopify. The initial project phase will focus on developing SKU-specific demand forecasting models. The initial focus will be on creating an automated inventory and supply chain tracking system to monitor stock levels and ensure timely restocks.
The project is expected to span a medium-term timeline of 3-6 months. Please communicate project updates via Slack. The specialist will have full access to our Shopify, Google Sheets, and Make.com platforms. The dashboards should include detailed data, drill-down capabilities, and extensive filtering options. The highest priority of the project is automating the inventory and supply chain tracking system to ensure timely restocks.