App Icon
Automatic mail merge, data processing, task tracking, and many more.
Listing updated:May 29, 2023
Works with:
224K+
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
►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
Michael Pyrch
May 30, 2023
I needed something that assigned a unique id to a google form submission in real time - something I could put in the response email along with the new record in google sheets. Nothing in google form add-ons seemed like the perfect solution. After stumbling upon this google sheets add-on I found it was the perfect solution to what I needed. I could capture the row number of the added record that the google form inputs and use that variable in the email being sent - an id that both the recipient and creator can reference amongst an abundance of submissions.
Is this review helpful?
Yes
No
Profile Picture
Krishna Balaji
May 5, 2023
First and foremost, I appreciate how easy it is to use this tool. With just a few clicks, I can automate repetitive tasks like data entry, sorting, and filtering. This has saved me countless hours of manual work and allowed me to focus on more important tasks that require my attention. Furthermore, Google Sheet Automation has a wide range of features that make it a versatile tool. From conditional formatting to custom functions, I have found that this tool has everything I need to manage and manipulate data in a way that suits my needs. One thing that really sets Google Sheet Automation apart is its integration with other Google services. For example, I can easily import data from Google Forms, or export data to Google Drive, Gmail, or Google Calendar. This seamless integration has made my workflow even more streamlined and efficient. Finally, I appreciate the level of support and resources that are available to users of Google Sheet Automation. The documentation is thorough and easy to follow, and there are countless tutorials and resources available online to help me get the most out of the tool. In summary, I highly recommend Google Sheet Automation to anyone who works with data on a regular basis. This tool has saved me time, improved my workflow, and allowed me to be more productive. Five stars all around!
Is this review helpful?
Yes
No
Profile Picture
Lauren Seppala
May 9, 2023
Knocked 4 hours off my work day each day with this app. Super easy to set up automations. Leaves clean formatting when moving from one tab to the next. I've recommended it to everyone I work with.
Is this review helpful?
Yes
No
Profile Picture
HARI PRASATH
May 18, 2023
Good, Easy and Very useful application of Automation of mails based on Cell values. can be given validation as well to stop unwanted mails.
Is this review helpful?
Yes
No
Profile Picture
Art rab
May 6, 2023
All the features are useable and I really like the integration of webhooks and API calls. Another good thing is they keep on adding more features. Highly recommended!
Is this review helpful?
Yes
No
Profile Picture
Ashutosh Upadhyay
March 28, 2023
I am trying to update my first trigger and getting this message : Saving rule failed due to unexpected error, please contact support for assistance. any fix for this ? it's damn annoying as it wouldn't let me do anything haven't had an opportunity to use the app yet because of this reason. eager to check it out
Is this review helpful?
Yes
No
Profile Picture
Jessica Rzepecki
May 25, 2023
I am super bummed. This was rated so highly but it doesn't work at all for me. Once I add a rule, it disappears forever and I have no ability to edit it or delete it. There is no list, no nothing, but the rules keep running. The only thing I could do was remove the add-on to get it to stop. I was trying to do something extremely simple, and it never took. I feel like there's some kind of bug for me because everyone else is reviewing so highly, but I couldn't get even the most basic of the basic to work. 3 hours down the drain and all I actually wanted to do was copy rows to a new sheet.
Is this review helpful?
Yes
No
Profile Picture
Máté Ferenczi
April 17, 2023
I recently started using the "Google Sheet Automation" addon and I must say, it has completely transformed the way I work with Google Sheets. This addon is a game-changer for anyone who spends a lot of time working with large datasets or performing repetitive tasks.
Is this review helpful?
Yes
No
Profile Picture
Steven Lutsky
January 24, 2023
Absolutely the best and most flexible Google Sheets automation offering out there and I have definitely tried them all. Totally customizable rules, with endless options to fine tune the rules to your workflow. Couldn't recommend it highly enough!
Is this review helpful?
Yes
No
Profile Picture
Carter Pochynok
January 10, 2023
Extension itself works very well, even if it's a little slow sometimes. That said, I never even got to use the extension in real-life because their free plan allows too few triggers for me to even finish testing the spreadsheet. Needless to say, the tool I built with this extension will never see the light of day as a result. To make matters worse, there is no control over default settings so if you prefer your program to insert a new row and shift down instead of up you're just screwed. I don't see why anyone would ever pay money for this. It's literally just taking advantage of people who don't know how to code. I will happily re-write all of the functions in Google App Script to avoid EVER having to use this shakedown machine.
Is this review helpful?
Yes
No
1-10 of 160
Search
Clear search
Close search
Google apps
Main menu