Google Apps Script macros that add one-click automation to any Google Sheet. Paste the code once — then click a button to run it anytime. No add-ons, no installs, no data leaves your sheet.
✓ Works in any Google Sheet✓ Any browser, any OS✓ No add-ons or installs✓ Paste once, use forever
// What's Inside
5 Ready-to-Paste Macros
01 /
🔁 Remove Duplicates
One click removes all duplicate rows from any Google Sheet — by full row match or by a key column you choose. Shows count of removed rows. Works on sheets of any size.
full-row dedupsingle-column keykeeps first occurrencerow count report
Extensions → Apps Script → paste → save → run
02 /
🎨 Auto-Format
Applies professional formatting to your entire sheet instantly: bold headers, alternating row colors, auto-fit column widths, freeze first row, and set consistent font + size throughout.
Scans a column for blanks, duplicates, or invalid formats (email, phone, date). Highlights problem cells in red and generates a summary report on a new sheet tab.
Sends each selected row as a formatted email to the address in a specified column. Great for sending personalized emails to a list without leaving your sheet — no Mailchimp needed.
per-row email sendcolumn-based addresscustom subject lineGmail API built-in
Extensions → Apps Script → paste → save → run
05 /
📤 Pivot Export
Creates a pivot table summary from any raw data sheet and exports it as a new tab. Group by any column, count or sum values, and get a clean pivot in seconds without manual table setup.
group-by any columncount or sumexports to new tabauto-formatted output
Extensions → Apps Script → paste → save → run
// Your Download Includes
Everything in One ZIP
All 5 .gs script files (fully commented)
Step-by-step setup guide for each macro
Paste once into Apps Script — runs forever
Compatible with any Google Workspace account
No admin permissions or add-ons required
Lifetime access — download anytime
// Questions
Frequently Asked
Do I need any coding knowledge?
No. Each macro comes with a paste-and-run guide. You open Extensions → Apps Script in Google Sheets, paste the code, save it, and run it. Takes under 2 minutes.
Will these work in my Google account?
Yes — they work in any personal or Workspace Google account. No admin permissions required. The macros run entirely within your own Google environment.
Can I use these on multiple sheets?
Yes — copy the script into any sheet you want. One purchase, unlimited sheets, forever.
What if a macro doesn't work for my sheet's structure?
DM @thedizzyinc on Instagram and I'll fix it for your specific sheet or give you a full refund.
How do I receive the files after purchase?
Payhip sends your download link to your email the second payment clears. Download the ZIP, open the .gs files in any text editor, and paste into Apps Script.
Secure checkout · Instant ZIP delivery · No subscription · DM @thedizzyinc if anything doesn't work
🛡️
Works in your Sheet or you don't pay.
If a macro doesn't paste correctly or run in your Google Sheet, DM @thedizzyinc on Instagram. I'll walk you through it — and if we can't make it work, I'll refund you. No forms, no ticket system. Just a DM.