Google Sheets Data Automation & Data Visualization Specialist (Canva Integration)

OVERVIEW We're a design studio delivering an interactive annual impact report for a mission-driven nonprofit. The report is built as a website in Canva and published in 70+ tailored versions, one per partner organization, all driven by data from a Google Sheets workbook. We're looking for a spreadsheet and data-visualization specialist to rebuild the data layer so it's clean, scalable, and reliably feeds the report's charts with minimal manual work. THE CORE PROBLEM YOU'LL SOLVE Currently every partner lives on a separate tab in one large workbook, and the data is arranged so a fixed cell range always holds a given chart's data on each tab (for example, the same rows always feed a "program satisfaction" bar chart). Because those ranges must line up across all tabs, rows can never be deleted, only hidden, so even a partner with a single program carries 400+ rows of hidden data. On top of that, the Google Sheets to Canva chart sync that used to auto-fill the charts stopped working, forcing manual data entry across dozens of reports. Your job is to fix both: restructure the data so each partner's figures are pulled by name or key rather than fragile fixed row position (so rows can be deleted and sheets stay lean), and re-establish a dependable, few-clicks pipeline from the sheet to the report's charts. WHAT YOU'LL DO •⁠ ⁠Diagnose why the Google Sheets to Canva sync fails and identify the reliable path. Variables to test include file size, sheet structure, and Google Drive storage location (personal vs shared drive). •⁠ ⁠Restructure the workbook using lookups (XLOOKUP / FILTER / QUERY / named ranges) so data is keyed by partner rather than by cell position. •⁠ ⁠Decide and implement the best architecture: one restructured workbook vs. a separate lightweight file per partner. •⁠ ⁠Build a clean "chart feed" structure that Canva, or an embedded chart tool, can bind to reliably. •⁠ ⁠Recommend native Canva charts vs. embedded charts (Datawrapper or Flourish) per chart type (bar, pie, and gauge/percentage dials), prioritizing reliability and clean labeling. •⁠ ⁠Make chart and data updates near-automatic across 70+ report versions. •⁠ ⁠Document the final system and write a short handoff guide so a non-technical team can maintain it. REQUIRED SKILLS •⁠ ⁠Advanced Google Sheets: complex formulas, lookups, data modeling, named ranges •⁠ ⁠Data visualization experience (bar, pie, gauge charts) with an eye for clarity and accessibility •⁠ ⁠Hands-on Canva experience, especially its chart/data features and Google Sheets connection •⁠ ⁠Ability to design spreadsheet structures for scale and easy repeat updates •⁠ ⁠Clear written communication and documentation NICE TO HAVE •⁠ ⁠Datawrapper and/or Flourish experience (live-syncing embedded charts) •⁠ ⁠Familiarity with WCAG 2.1 accessibility for data visualization •⁠ ⁠Experience building templated or duplicated deliverables at scale TO APPLY, PLEASE ANSWER 1.⁠ ⁠Describe a project where you connected Google Sheets data to a live chart or dashboard that updated with little to no manual work. What tools did you use? 2.⁠ ⁠How would you structure a spreadsheet so a specific record's data can be pulled by a name or key rather than a fixed cell position? 3.⁠ ⁠Rate your Canva experience from 1 to 10 and briefly describe what you've built in it, including any work with its charts or data connections.