App Icon
The best Google Sheets automation tool. Send emails, Slack messages automatically.
Listing updated:January 23, 2023
Works with:
177,578
Overview
Manually doing time-consuming and repetitive tasks every day is frustrating.

Why not automate the boring stuff and find more time in your life?

Learn how to use Logic Sheet to save your time and boost productivity by automating repetitive tasks. Set up a single automation workflow, and let Logic Sheet do the action for you.

You can set up automation workflows to let Logic Sheet send an Email notification or send a Slack message when your spreadsheet is edited. You can also set up workflows that run every hour or every day and check the latest data in your spreadsheets. Or just get notified when a new form is submitted to your Google Sheets.

🤖️ What you can do with Logic Sheet Automation:

- ⌚️ Set up triggers that run at a specific time
- 🕙 Set up triggers that run at a fixed interval (hourly, daily, weekly, or monthly)
- 🌟 Set up triggers that listen to spreadsheet edits
- 🥳 Set up triggers that listen to form submission
- 🪝 Set up webhooks to trigger automations
- ⁉️ Set up conditions for each automation workflow
- 📧 Send email notification when the automation is triggered
- 💬 Send a Slack message when the automation is triggered
- 🔄 Hard refresh the spreadsheet when the automation is triggered
- 🆕 Update a spreadsheet by setting a new value or a new formula in a cell
- 💾 Add a new record to your Airtable base using values in Google Sheets
- 🏷️ Use merge tags to refer to dynamic data in your message... more to come as we keep improving the product.

______________________________________________________________________________
 Data processing

In addition to automation, you can also use Logic Sheet to import data from API or databases to your Google Sheets. You can use Logic Sheet to analyze your data statistically and extract meaningful insights from it.

A typical data-analysis task involves three steps: data collection, data cleaning, and data analyzing. With Logic Sheet, you can do them all in only one tool.

=====Data collection ====================

In the data collection process, you can use Logic Sheet to import data from external sources into Google Sheets. That includes importing data from API, databases, or webpages. Our API Connector can help you make GET and POST requests to API, and the Database Connector can help you pull data right from an online database.

With Logic Sheet's API Connector function, it's now easy to make POST GET PUT PATCH and DELETE requests to any JSON data source and import REST API data directly to your spreadsheet. This means you can import JSON from any URL. 

Features:

- Data organizer: Import nested JSON data into Google Sheets
- Use OAuth authentication and simple API key authentication
- Data connector for Salesforce, Airtable, IBM, Alpha Vantage, Crunchbase, DeepL, Facebook ads, Goole Analytics, HubSpot, Instagram, Spotify, Apple Music, Mailchimp, Salesforce, Xlminer, Flex.io, Portant, Sheetgo, Slack, CSV,  Notion, Youtube, and Stripe using our API connector
- Data connector for Salesforce
- Send data to API from your worksheets.
- Use our =LogicSheetAPI custom function to interact with APIs.
- Use our latest =LogicSheetAirtableSync formula to Sync your Airtable data into Google Sheets and keep it up to date.

Compatible with: Notion2Sheets, Apipheny, SyncWith, Supermetrics, Workspace Automation, Mixed Analytics, Zapier

Database browser: You can use Logic Sheet to connect to a MySQL database and import data from the database using our database connector function. 
- Use our LogicSheetMySQL custom formula to run SQL queries directly from Google Sheets.

Data scraping: Scrape structured data from any website page using our webpage crawl (ImportFromWeb) function.

=====Data cleaning=====

In the data cleaning stage, you can use Logic Sheet to remove incorrect or superfluous data, as well as check for incompleteness or inconsistencies. For instance, you can use Logic Sheet to filter spaces in front of letters or symbols or remove duplicates.

- Remove duplicates: Remove all extra rows that have duplicate values in each cell to clean dataset.
- Case Converter: Change text casing of all values of the selected range into upper case, lower case, pascal case, title case, proper case, camel case, snake case, sentence case, train case, or kebab case.
- Unpivot data: Transform a pivot table into a regular tabular sheet.
- Split names: Use the Split names function to split a full name into smaller parts (first name, middle name, last name, salutation, suffix, etc.). The Split names function recognizes over 100 titles (Mr. Dr. Prof. etc.) and 50 post-nominals (CFA, Ph.D., etc.)
- Split address: Parse a column of addresses into smaller parts (street address, city, state, postal code, etc.)

Other clean data features:

- Round number
- Remove leading spaces
- Trim trailing spaces
- Remove non-numbers
- Remove number
- Remove punctuations
- Format data and clean data
- Convert Unix timestamps

=====Data analytics=====

Finally, you can use Logic Sheet to run statistical analysis on your data and extract meaningful insights from it. That includes ANOVA, F-test, T-test, and more. With our analysis tool, you will be able to find hidden patterns, relationships, insights, and predictions from your data.

>> Data Analysis Toolpak 🛠

Get the Analysis ToolPak that used to only be available in Excel.

- ANOVA, or Analysis of variance: Use Logic Sheet to do ANOVA analysis, calculate the sum of squares, variance, mean squares, P-value, and F crit value. Both ANOVA (ANOVA Single Factor) and two-way ANOVA (two-factor ANOVA) are supported.

- Correlation: Find the correlation coefficient between two or more variables.

- Covariance: Calculate the joint variability of two random variables.

- Descriptive Statistics: Describe the basic features of the data including Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Confidence Level (Confidence Interval), and more.

- F-Test for two sample variances: A test that uses the F-distribution. This function uses the F Test to compare two variances.

- z-test: a hypothesis test that determines whether two population means are different when the variances are given.


=====Other features=====
 

>> Calculate 🧮

Use Logic Sheet to insert a cumulative sum column or insert a growth rate column next to the selected column.

- Insert running totals: Insert a column of cumulative totals of the selected column next to it
- Insert growth rate: This function will insert a column of growth rate values of the selected column next to it

______________________________________________________________________________

>> Finance 💵

Logic Sheet can help you import stock prices, financial statements, and foreign exchange rates into your spreadsheets and simplify your financial analysis workflow.  It's easy and flexible to use.

> Get real-time share price or weekly and monthly stock price history of a company

> Import company financial information, including income statement, earnings, balance sheet, cash flow, and company overview into your spreadsheet

> Import real-time forex rates (foreign exchange rates) and historical forex rates

> Import real-time cryptocurrency prices or historical data

Supported cryptocurrencies: https://app.logicsheet.co/financesupport#supported-cryptocurrencies 

______________________________________________________________________________

For more information about Logic Sheet, please visit: https://app.logicsheet.co/

If you have any questions, please contact the developer at wei@logicsheet.co, I will reply to you in less than 24 hours.

If you have any trouble using Logic Sheet, please take a look at our detailed documentation here: https://docs.logicsheet.co.
Additional information
PricingFree of charge trial
Privacy policy
Terms of service
Logic Sheet - Automate your spreadsheets will ask for the permissions shown below. Learn more
Logic Sheet - Automate your spreadsheets will need access to your Google account
This will allow Logic Sheet - Automate your spreadsheets to :
Create and update Google Apps Script projects
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
Create and update Google Apps Script deployments
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
Philip
December 11, 2022
This is a great tool to have with you if you are working with google sheet data. With the tool you also get great support and quick responses in case you're stuck somewhere.
Is this review helpful?
Yes
No
Profile Picture
Grogan Brian
November 12, 2022
I love how this add-on is constantly rolling out new features. The recent webhooks and HTTP request features are nailing it. Wei the developer is very helpful and answers my questions instantly even if I'm not a paying user.
Is this review helpful?
Yes
No
Profile Picture
Mason Kobliska
October 7, 2022
So far it seems like a very helpful tool to run mundane tasks of a business.
Is this review helpful?
Yes
No
Profile Picture
Joe Engles
August 4, 2022
Not as good as advertised. Most features are half-baked. Tried the api connector feature, it does not even support saving a request on UI. Some other important features like pagination, column mapping are also missing.
Is this review helpful?
Yes
No
Profile Picture
Chintan Karnik
November 7, 2022
With the newly launched webhook feature, automating tradingview alerts into google sheet is a breeze.
Is this review helpful?
Yes
No
Profile Picture
Concierge Paris
June 25, 2022
Not as advanced as Syncwith or Apipheny, and it's missing the PUT, PATCH, DELETE, UPDATE method as well as the URL ENCODED body parameters method (application/x-www-form-urlencoded) So you won't be able to use any api you want.
Is this review helpful?
Yes
No
Profile Picture
Phuong Nguyen
March 24, 2022
I use Google Sheets for my data processing, but I recently came across LogicSheet, which has made my life much easier. It efficiently automates repetitive tasks, but it's also easy to use and set up. The interface is clean, free of clutter, and incredibly user-friendly. I love how the tool is "smart" enough to adapt to a wide variety of tasks so that I don't need to learn anything new; instead, I can apply what I already know about Google Sheets for my personal and work-related needs. The fact that LogicSheet is constantly being upgraded with new features and functionality makes it an even more attractive tool to invest in!
Is this review helpful?
Yes
No
Profile Picture
Cyra Giampiero
July 29, 2022
This app does exactly what Google Sheets should have added to its functionalities. I use it to send API requests/webhooks to my Pushover notification app when I receive a Google Form submission. Works like a charm.
Is this review helpful?
Yes
No
Profile Picture
Henry Simanson
September 5, 2022
This addon covers everything from importing data to data analytics. And the automation feature is just a killer! Definitely recommended.
Is this review helpful?
Yes
No
Profile Picture
Ritch Cuvier
July 21, 2022
Really good tool. I was using the api option so much I had to upgrade; this is better than most tools to integrate with Google sheet. Can't wait for the api scheduler!!!
Is this review helpful?
Yes
No
1-10 of 27
Search
Clear search
Close search
Google apps
Main menu