Sheet Magic

Merges Google Sheet data into Google Slides templates and converts to PDF.

🇺🇸 English Sheet to Slide Merger Automatically merge Google Sheets raw data into Google Slides templates! Automate repetitive document tasks (certificates, invitations, name tags, reports, etc.) with just a few clicks. 🚀 Key Features Instant Data Sync: Automatically recognizes data from the currently open Google Sheet. Flexible Templates: Use Google Slides as a template. By placing headers from the first row in brackets like <<Name>> or <<Date>>, the tool will automatically replace them. Conditional Filtering: Extract only the data you want using <<HeaderName(ConditionHeader:Value)>>. For example, <<Date{Name:John}>> will only pull the date for rows where the name is "John". Group Merging: Group data by a specific column (e.g., 'Department'). For instance, if you want to generate two pages—one for Development and one for Design—set 'Department' as the merge criteria. Various Output Options: Individual PDF: Generates a separate PDF for each row. Merged PDF: Combines all results into a single PDF file. PPT Creation: Saves as Google Slides (PPTX) for manual editing before finalizing. 📝 How to Use Prepare Template: Open a Google Slide and put headers in << >>. Run Extension: Open your Google Sheet and click the 'Sheet magic' icon. Settings & Generate: Select your template, set the row range/filters, choose the output format, and start generating. 💡 Use Cases Event Name Tags: Participant list → Name tag layout → Print as PDF. Sales Reports: Monthly data → Report template → Save by period or department. Certificates: Completer list → Certificate format → Individual PDFs for email. Privacy: Your files are never sent to a server. All processes occur securely between your browser and Google Cloud.