Automatic mail merge, data processing, task tracking, and many more.
Listing updated:June 14, 2024
Works with:
236K+
Overview
Sheet Automation is a powerful, easy-to-use extension that takes Google Sheets to next level. Create your mini workflow with the intuitive UI and automate everything without writing script.

###POPULAR USE CASES###

✅ AUTOMATE YOUR SPREADSHEET
You are probably using the great formula or built-in feature to do some repetitive work, however you can easily find yourself losing track of condition after condition, formula after formula. With Sheet Automation’s simple, easy-to-use interface you can quickly and easily set up all kinds of automations. 
►Move or copy row across tabs or workbooks
►Copy data from specified columns
►Update arbitrary cells in the sheet
►Delete or hide row when they are not relevant
►Sort sheet when data is changed or based on schedule
►Conditional format on border, cell style, text alignment

✅ FORM RESPONSE HANDLING
With Sheet Automation, you can automatically send email messages every time a respondent submits Google Form. You can notify the form respondent, your team members, or create notification rules and send emails to different people based on the form answers.
►Send notification to owner when a new form is submitted
►Stop or resume accepting response 
►Insert edit url and send confirmation to submitter 
►Format the response row with the style you want
►Enrich the response with additional data or formula copy down
►Sort the latest answer to the top of the sheet
►Export the response data to PDF
►Upload the response data to external system via webhook

✅ TASK MANAGEMENT
With the collaboration nature of google sheets, it is great for team task management and coordination. Sheet Automation makes it fully automated. 
►Task status tracking and change logging
►Distribute tasks from master sheet to assignee’s individual sheet
►Notify team members on task status updating
►Monitor due date and send reminder on approaching deadline
►Archive completed or expired tasks automatically

✅ NOTIFICATION HUB
Paired with gmail, sheets could be your notification hub. With the flexible variable system provided by Sheet Automation, you can easily create personalised email based on predefined HTML template.
►Send notification when data is updated and condition is satisfied
►Send email with row or sheet as attachment
►Send reminder on hourly, daily, weekly schedule
►Send alert when due date is close or date time condition matches
►Send Slack, SMS, WhatsApp messages through webhook

✅ DATA PROCESSING SOLUTION
You can bulk process your sheet data based on the powerful utilities provided Sheet Automation:
►Automatically enrich row and populate data
►Sync data between two sheets
►Move data across sheets or spreadsheets.
►Send data from sheet to third-party services
►Import JSON data from HTTP API 

✅ TURN SHEET INTO A LIGHTWEIGHT CRM
If you are using Google Sheets to store information of customers, subscription like we do, Sheet Automation can simply make it into a CRM.
►Send personalised marketing email
►Automatic response to customer inquiry
►Send reminder for subscription expiration or payment failure
►Assign sales leads to representative
►Export sheet and send invoice on schedule
►Integrate with other CRM via api connector

✅ COMPLEMENT YOUR EXISTING WORKFLOW
Sheet Automation can be integrated into your existing workflow seamlessly if you are using tools like AppSheet, Glide apps, Hexomatic, Zapier, Pabbly to automate your business. 
►Trigger a workflow from sheet update
►Send alerts when a new row is appended by AppSheet
►Transform data format and pass it to pabbly webhook
►Publish data to Pabbly using webhook

###FEATURES###

► Trigger on sheet update
► Trigger on schedule or timer
► Support trigger from third-party forms including JotForm, Wix and more
► Range condition to check any value in sheet
► Column condition to check value from relative row
► Variable condition to check any variable
► Formula like expression language
► Rule import/export
► Call Webhook or HTTP service
► Move/copy/create rows 
► Update any column of the row
► Update any cell of the sheet
► Create new sheet and spreadsheet
► Sort sheet or specified range
► Export row or sheet to PDF
► Format row
► Lookup row in another sheet
► Delete row
► Hide row
► Conditional action
► Custom event *
► Concurrency control *

###PRICING###
We offer a generous FREE tier with most of the features. Many of our users stay with the free tier as the quota is enough for their work. We are happy that Sheet Automation is helpful for individuals and small businesses.  

Find detailed pricing from: https://www.sheetautomation.com/pricing.html

We also have a free/discount program to support schools and not-for-profit organisations. Please reach out if you have a need. 

Additional information
PricingFree of charge with paid features
Developer
Privacy policy
Terms of service
Sheet Automation - Automate Google Sheets will ask for the permissions shown below. Learn more
Sheet Automation - Automate Google Sheets will need access to your Google account
This will allow Sheet Automation - Automate Google Sheets to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Finance IDEALS
May 21, 2024
Sheet Automation is a game-changer! It has drastically increased our unit's productivity by automating repetitive tasks, allowing us to focus on more important aspects of our work. The user interface is intuitive, making it easier to set up and use, even for those who are not tech-savvy. The features are robust and flexible, catering to a wide range of automation needs. Excellent tool for anyone looking to streamline their workflow in Google Sheets! Highly recommended!
Is this review helpful?
Yes
No
Profile Picture
Chi Moseley
April 29, 2024
What a life saver! I have tried a few other extensions that claim to provide similar functionalities but none were as user friendly or intuitive as Sheet Automation. After many frustrating months of trying to understand and write scripts by myself, I happened to see an ad for Sheet Automation and decided to give it a try. I am so happy that I did! This tool takes all the guess work out of creating automations to help improve your work flow. I highly recommend it, especially for newbies like me.
Is this review helpful?
Yes
No
Profile Picture
CRM CENTER PARCS
April 16, 2024
Great tool that has allowed us to save a lot of time very easily on Google Sheets. It's awesome to have a super powerful Swiss Army knife without having to use more complicated solutions like Make. I completely recommend it!
Is this review helpful?
Yes
No
Profile Picture
ProGro Partners HR
April 16, 2024
Besides the low quota on the free plan, the automation works great and is extremely easy to use. Very friendly for those inexperienced with scripts, and is easy to edit, and implement. Wonderful product!
Is this review helpful?
Yes
No
Profile Picture
Jaime Crandall
March 11, 2024
This extension has really made an astounding difference in my workflow with scheduling clients and organizing my days - almost everything within my business is organized on spreadsheets. As a small business owner who started my business out of my own pockets in the aftermath of COVID, I can't thank the developers enough for their ingenuity and for allowing people like me to use their product for free. 5 stars, I'd give more if I could!
Is this review helpful?
Yes
No
Profile Picture
Taxx Savage
January 2, 2024
This tool on Google Sheets has been exceeding my expectations for the past few weeks with its 5-star rating. It's incredibly intuitive, just as explained, and it functions. That's the complete explanation. The discovery of this extension has genuinely made me happy. Kudos on the remarkable work, and continues to excel.
Is this review helpful?
Yes
No
Profile Picture
Vlad De los Reyes
May 23, 2024
Easy to use and works well with the automation that I need! I love the simplicity of its function!
Is this review helpful?
Yes
No
Profile Picture
Loni Anderson
June 10, 2024
So useful and easy to set up! Fully recommend to anyone using google sheets
Is this review helpful?
Yes
No
Profile Picture
Darve Smith
April 18, 2024
Love it! Saves time and a lot of hassle manipulating data in Google Sheets. Works just as stated and faster than expected.
Is this review helpful?
Yes
No
Profile Picture
Amy
May 29, 2024
This app is easy to use for beginners like me, and was just what I was looking for. I was looking for a way to 1) Sort tasks in my google sheet by priority and 2) Move completed tasks to a new sheet. This app did that perfectly. Thank you!
Is this review helpful?
Yes
No
1-10 of 137
Search
Clear search
Close search
Google apps
Main menu