Category: Google Spreadsheet Tips

How to Convert Google Sheets Data to JSON Data API

How to Convert Google Sheets Data to JSON Data API

This article explains how to convert Google Sheets Data to JSON Data API. You can convert Google Sheets data as a JSON API and use it as another fron ...
How to send HTML table in the email body using google app script

How to send HTML table in the email body using google app script

This article contains a Google App Script code to send auto email alerts for employees' leave transactions. Let's learn how to send an HTML table in ...
How to repeat a cell value to n times in google sheets

How to repeat a cell value to n times in google sheets

Assuming you have data in Column A, a list of products and you want to repeat them in the next column or in another sheet to n times. Let's assume yo ...
How to fill down blank rows using Arrayformula in Google Sheets

How to fill down blank rows using Arrayformula in Google Sheets

Assuming you have data in Column A, a list of products but it has some blank rows in between and you want to fill them down with product name itself. ...
How to get sheets name and rename them using Google Script

How to get sheets name and rename them using Google Script

Renaming all sheets in Google Sheets is a tedious task. If you do it manually, it'll kill your valuable time. Let's see How to get sheets name and re ...
How to use REGEX formulas in Google Sheets

How to use REGEX formulas in Google Sheets

REGEX formula is a great function created for Google Sheets. You will not find this function in MS EXCEL, you have to write a VBA script to apply reg ...
How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet

How to Remove Unwanted Text From Multiple Columns In Google Spreadsheet Removing unwanted text from multiple datasets is a tedious task, but Googl ...
How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes

How to send email notifications on Google Spreadsheets if any cell value changes Working on Google Spreadsheets is fun, you can do a lot with Goog ...
Open chat
Talentnett Solutions
Hello,

How may I help you today!

Regards,
Umesh Agarwal
Contact - +91 - 7017544508
Email - umesh.agarwal@talentnett.com

Cool Tips and Tricks Directly Delivered in your Inbox. Subscribe to our Newsletter.

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Talentnett will use the information you provide on this form to be in touch with you and to provide updates and marketing.