Free Google Sheets and Gmail scripts for small businesses

Short answer: Pushbuild has 53 free Google Apps Scripts for small businesses, each with written setup steps. Enter your email on a script’s page and we send you the code. You paste it into Extensions, then Apps Script, in a Google Sheet, and it runs in your own Google account.

How these scripts work

• Free: enter your email on a script's page and we send you the code.
• Runs in your Google account: you paste it into Extensions, then Apps Script, in a Google Sheet. Most scripts send nothing to us.
• A menu in your sheet: each script adds its own menu, so you start, stop and run it without opening the code.

All scripts

• Auto-numbered invoices in Google Sheets, emailed as a PDF in one clickA free Google Apps Script that numbers every invoice for you, saves it as a PDF, emails it to your client and logs it, from one button in your sheet.Video and written steps
• Send your website form straight into Google SheetsA free Google Apps Script that adds every website form entry to a Google Sheet as a new row, with the time it arrived. No Google Forms, no plugin.Video and written steps
• Add your own menu and buttons to Google SheetsA free Google Apps Script that adds a Tools menu next to File and Edit: sort a task list by due date, highlight what's overdue and clear finished rows, in one click.Video and written steps
• Turn PDF bank statements and invoices into Google Sheets automaticallyA Google Apps Script that turns the tables in a PDF on your Google Drive into a new tab in Google Sheets.Video and written steps
• Excel files that update Google Sheets automaticallyA free Google Apps Script that imports every Excel file in a Google Drive folder into its own tab, and checks the folder again every morning.Video and written steps
• Combine every tab into one master sheet in Google SheetsA free Google Apps Script that builds a Master tab from all your tabs, with a Source column showing where every row came from.Video and written steps
• Split one Google Sheet into tabs by categoryA free Google Apps Script that splits one big list into a tab per region, rep or any other column, in one click.Video and written steps
• Make a Google Doc and PDF for every row in your sheetA Google Apps Script that fills a template with each row of your sheet and saves one PDF per row in Google Drive.Video and written steps
• Invoice every client automatically on the 1st of the monthA Google Apps Script that makes an invoice PDF for every client in your sheet and emails it from your own Gmail.Written steps
• Get an email when stock runs low in Google SheetsA free Google Apps Script that emails you once when an item drops to its reorder point, and not again until it's restocked.Written steps
• Log important emails into Google Sheets automaticallyA free Google Apps Script that adds every Gmail message with your chosen label to a Google Sheet, with a link back to the email.Written steps
• Auto reply in Gmail only outside your business hoursA free Google Apps Script that answers new emails only when you're closed, such as evenings and weekends, and stays quiet during your open hours. Gmail's own vacation responder can't do that.Written steps
• Send estimates from Google Sheets and turn them into invoices in one clickA free Google Apps Script that numbers each estimate, emails it to your client as a PDF and, once they say yes, turns the same row into a numbered invoice and emails that too.Written steps
• A simple CRM in Google Sheets that tells you who to follow up withA free Google Apps Script that turns a contact list into a small CRM: change a contact's stage and the next follow-up date fills itself in, and every morning you get an email listing who to contact today.Written steps
• Take bookings with a Google Form and put them straight on your calendarA free Google Apps Script that turns each Google Form booking into a Google Calendar event with the customer invited, and emails them to pick another time if that slot is already taken.Written steps
• Turn a Google Sheets timesheet into pay-period totals with overtimeA free Google Apps Script that adds up each employee's hours for a pay period, splits out overtime over 40 hours a week, works out gross pay from their hourly rate, and can email each person their hours.Written steps
• A mileage log in Google Sheets that works out the miles for youA free Google Apps Script that fills in the driving distance for each trip from the From and To addresses using Google Maps, doubles it for round trips, and totals your miles by month.Written steps
• Get an email with every answer the moment someone fills in your Google FormA free Google Apps Script that emails you each new Google Form entry with all the answers in the message, so you can reply straight to the person, and can send them a thank-you email too.Written steps
• Send polite overdue invoice reminders from Google Sheets automaticallyA free Google Apps Script that checks your invoice list every morning and emails a polite reminder from your Gmail when an invoice is overdue, on the days you choose, until you tick it as paid.Written steps
• Back up your important Google Sheets and Docs every nightA free Google Apps Script that copies the Google Sheets, Docs and folders you list into a dated folder in Google Drive every night, and deletes copies older than the number of days you choose.Written steps
• Get a text message when someone fills in your website formA free Google Apps Script that adds each website form entry to a Google Sheet and sends you a text message with the details, through your own Twilio account, so you can call the lead back in minutes.Written steps
• Send personal text messages to a list in Google SheetsA free Google Apps Script that sends a text to everyone on a list in Google Sheets, with each person's first name in the message, through your own Twilio account, and marks each row sent or the error.Written steps
• Ask every customer for a Google review automatically after the jobA free Google Apps Script that emails a short Google review request when you tick a job as done in Google Sheets, after a wait you choose, and only once per job.Written steps
• Turn scanned PDFs and photos into editable text, automaticallyA free Google Apps Script that reads every scan or photo you drop into a Drive folder, typed or handwritten, makes an editable Google Doc of it and puts the text in your sheet.Written steps
• Clean up messy sheet data and remove duplicate rows in one clickA free Google Apps Script that tidies a whole tab (extra spaces, email case, phone formats) and moves duplicate rows to their own tab, so nothing is deleted.Written steps
• Get your Google Sheets data ready for a Power BI dashboardA free Google Apps Script that combines your monthly or per-location tabs into one clean table, plus a calendar table, ready for Power BI to read.Written steps
• Pull data from any API into Google Sheets on a scheduleA free Google Apps Script that calls a JSON API, turns the results into rows and columns, and refreshes the tab every hour.Written steps
• Email your Google Sheet as an Excel file every week, automaticallyA free Google Apps Script that sends the whole spreadsheet, or one tab, as an .xlsx attachment, now or on the same day every week.Written steps
• Save Gmail attachments to Google Drive automaticallyA free Google Apps Script that saves the attachments from the emails you choose into a Drive folder every 15 minutes and logs each file in your sheet.Written steps
• An expense tracker in Google Sheets that sorts and totals itselfA free Google Apps Script that puts each expense into a category from your own keyword rules and builds a table of totals by month and category.Written steps
• Text appointment reminders from Google Calendar automaticallyA free Google Apps Script that texts each customer a reminder before their appointment, using the phone number in the calendar event. Sent through your own Twilio account.Written steps
• New client intake form that sets up their Drive folder for youA free Google Apps Script that, when a new client fills in your Google Form, creates their Drive folder, copies your template documents in with their details filled, and sends a welcome email.Written steps
• Copy Google Calendar events into a sheet with hours totalledA free Google Apps Script that lists every event in a date range with its start, end and hours, then totals the hours for each event name. Handy for timesheets and client billing.Written steps
• A free website uptime monitor that emails you when your site goes downA free Google Apps Script that checks your websites every 5 minutes and emails you when one stops answering, and again when it is back, with how long it was down.Written steps
• Back up a Google Drive folder automatically every weekA free Google Apps Script that copies a Drive folder, subfolders included, into a dated backup every week and keeps only the last few.Written steps
• Copy Stripe payments into Google Sheets automaticallyA free Google Apps Script that copies your Stripe payments into a Google Sheet every hour, with the amount, status and customer email, and never adds the same payment twice.Written steps
• Copy Square sales into Google Sheets automaticallyA free Google Apps Script that copies your Square payments, card and cash, into a Google Sheet every hour, ready for totals and bookkeeping.Written steps
• Copy PayPal transactions into Google Sheets automaticallyA free Google Apps Script that copies your PayPal business transactions into a Google Sheet every hour, with the amount, status and payer email.Written steps
• Copy new Shopify orders into Google Sheets automaticallyA free Google Apps Script that copies every new Shopify order into a Google Sheet each hour, with the customer email, total, payment and fulfillment status and the items.Written steps
• Copy WooCommerce orders into Google Sheets automaticallyA free Google Apps Script that copies your WooCommerce orders into a Google Sheet every hour, with status, total, customer email and items.Written steps
• Copy Calendly bookings into Google Sheets automaticallyA free Google Apps Script that copies your Calendly bookings into a Google Sheet every hour, with who booked, when and where, and marks the ones that get cancelled.Written steps
• Keep a copy of your Mailchimp list in Google SheetsA free Google Apps Script that copies your Mailchimp audience into a Google Sheet every hour: email, status, name, signup date and tags.Written steps
• Keep a copy of your HubSpot contacts in Google SheetsA free Google Apps Script that copies your HubSpot contacts into a Google Sheet every hour, for reports, mail merges or a backup.Written steps
• Send personal emails from Google Sheets with Gmail (mail merge)A free Google Apps Script that sends each row of your sheet its own email from your Gmail, with names and details filled in, and marks who has been sent one.Written steps
• A simple inventory tracker in Google Sheets with low stock emailsA free Google Apps Script that keeps stock levels from a log of what comes in and goes out, and emails you each morning about anything at or below its reorder level.Written steps
• Post every new form lead to Slack instantlyA free Google Apps Script that posts each new Google Form response to a Slack channel the moment it arrives, so nobody waits on a lead.Written steps
• Build a simple sales dashboard in Google Sheets automaticallyA free Google Apps Script that turns any list of sales or expenses into a one-page dashboard: this month, last month, year to date, the last 12 months as a chart, and your top customers or products.Written steps
• Pull invoice details from PDFs into Google SheetsA Google Apps Script that reads every PDF invoice in a Google Drive folder and adds one row per invoice: vendor, date, invoice number, subtotal, tax and total.Written steps
• Log receipt photos into Google SheetsA Google Apps Script that reads the receipt photos in a Google Drive folder and adds one row per receipt: merchant, date, tax and total.Written steps
• Fill a PDF form for every row in Google SheetsA Google Apps Script that fills a fillable PDF form once for each row of your sheet and saves the filled PDFs in Google Drive.Written steps
• Merge the PDFs in a Google Drive folder into oneA Google Apps Script that merges every PDF in a Google Drive folder, in order of file name, into one PDF saved in the same folder.Written steps
• Copy a table from a website into Google SheetsA Google Apps Script that copies a table from a web page into Google Sheets, and refreshes it whenever you run it again.Written steps
• Website uptime and SSL monitor in Google SheetsA Google Apps Script that checks your websites every hour from our server and emails you when one goes down or its SSL certificate has less than 14 days left.Written steps

Questions

Are these scripts free?

Yes. Enter your email on a script’s page and we send you the code.

Where do the scripts run?

In your own Google account: you paste the code into Extensions, then Apps Script, in a Google Sheet. Most scripts send nothing to us.

How do I run one after it is installed?

Each script adds its own menu to your sheet, so you start, stop and run it without opening the code.

Can you install one for me or change it?

Yes. Send us a short brief and we install it or change it to fit how you work.

More free tools: free n8n workflow templates, PDF to Excel and Excel to Google Sheets.

Want one installed, or changed to fit how you work? Send us a short brief.