قالب وردپرس درنا توس
Home / Tips and Tricks / The best additions to Google Sheets

The best additions to Google Sheets



Google Sheets extensions work the same as browser extensions. They are third-party applications you install to Archive for additional features. Some extensions increase productivity, and some add more comprehensive features. This is how you begin.

Installing a Add-on

To get extensions, open a new or existing file in Google Plates, click "Add-ons", and then click "Download Add-ons."

  Open the Add-on menu, and then click Get Add- Ons

You can browse the list of all extensions, use the drop-down menu to sort by category or search with the search field. Once you have found an extension you want, click the "Free" button to install the add-on (if it is a paid addition, this button will reflect the purchase price).

  searching for extensions by category or with the search box

When installing extensions, you need to grant them specific permissions. These are fundamental to the proper functioning of the supplement. Make sure you fully understand the permissions and trust the developer before installing any extension.

Click "Allow."

 Allow an app for certain permissions

After installing an extension, click "Add-ons", tap the one you want to use, and then click "Start" or "Open. " This starts the extension or docks the sidebar in your window.

 Open / start an extension

Delete an extension

If you no longer need an extension, it's easy to remove from Google Sheets.

From your document, click "Add-ons, then click" Manage Add-ons. "

 Click Manage Add-ons

In the window that pops up, scroll down to the extension you want delete, click the green "Manage" button, then click "Delete."

 Click Manage and then click Delete

The selected extension is deleted and the management button is replaced now with blue

 After removal, the free button

appears Our favorite add-on

Now, with how to do things out of the way, let's move on to some of

Tools: Automate Boring Tasks [19659023] Tool screen dump ” width=”650″ height=”373″ src=”/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/>

Tool tool is a set of 20+ features that help you complete common and boring and complex tasks.Each tool is designed to make computing easy for everyone, reducing clicks on repeated tasks by h find out the formulas and operations you use the most so you can quickly apply a set of actions in different areas. But that's not all; You can find duplicate or unique records, match and merge data, compare sheets, shared text, and so much more.

Tools are free for the first 30 days, $ 43 for the year and $ 90 for a lifetime license. 19659022] Doctopus: "Hand Out" Documents

  Doctopus Screenshot

Doctopus is built with teachers in mind. It allows you to copy and "send" your Google Drive files to a specified list of students, giving you complete control over how to handle your assignments.

When used with Goobric (Google + Heading) Doctopus, you can create headlines and shorten the time taken to read, comment, and rate the student's work on headlines, even leave audio comments on a student's work.

Doctopus is 100% free to use.

WolframAlpha: Find facts and calculation forms

  WolframAlpha Screenshot

It is hard enough for them to get something done on your computer without distracting to open a new tab and get lost in a rabbit hole that is the internet . With the help of WolframAlpha's free add-on, you don't have to leave Google Sheets to search the internet to find mathematical calculations, science and technology, historical facts, and so on.

It is hard enough for these days to get something done on your computer without distracting to open a new tab and get lost in a rabbit hole that is the internet. With the help of WolframAlpha's free add-on, you never have to leave Google Sheets to search the internet for mathematical calculations, science and technology issues, historical facts, and so on.

WolframAlpha uses large databases and algorithms to answer questions, do analysis and generate reports for almost anything you can think of or may need to know. In your worksheet, select which text or cells you want to calculate – or just find more information about – then click "Calculate Wolfram Alpha Selection" to replace the selected text with its results. Then click on the WolframAlpha add-on menu. [19659008]   WolframAlpha Query

Supermetrics: Generating Business Reports

  Supermetrics Screenshot

Supermetrics is a powerful add-on that transforms your Google Sheets into a complete business reporting system, with integration using SEM, SEO, web analytics and social media. Drag data across multiple websites in a spreadsheet, saving time and effort to compare data across portfolios. It connects analytics tools like Google Analytics, AdWords, Facebook ads, Twitter ads, Amazon ads, Instagram and many more.

To import data, you can only use filters to select fields that you want to add to the worksheet. Spreadsheets are then updated automatically and keep all your data up to date. Then, you can configure automatic emails to send out PDF, Excel, CSV, or HTML formats, even giving access to your reports with Google's sharing options.

Supermetrics is free for 14 days; Afterwards, you can continue to use it for free with limited features or upgrade to Pro or Super Pro versions for $ 69 / user / month and $ 149 / user / month respectively.

Twitter Archive: Save Tweets to Sheets

  Twitter File Screenshot

With Twitter File, you can easily save tweets to Google Sheets using any keyword or hashtag. Once you enter a search query, all tweets that match your query are automatically saved in the Google Sheets spreadsheet. Save tweets around trending hashtags, your brand mentions, geo-tagged tweets and more.

Twitter Archive is free to use, but a premium account has access to capture more keywords, more Twitter rules, and reduced polling cooling. Free user poll Twitter once an hour, while premium users poll every 10-15 minutes.

Template Gallery: Find Amazing Templates

  Template Gallery Screenshot

Save time with professionally crafted templates for your Google Sheets worksheets with Mall Gallery. Choose from calendars, schedules, magazines, financial calculators, invoices and many more. After clicking on a template you want, the add-in saves a copy of the template directly to your Google Drive root folder.

The mall gallery is completely free to use.

Another Mail Merge

  Another Mail Merge Screenshot

Another Mail Merge (YAMM) lets you send email based on templates to your contacts, automates email campaigns and tracks the e-mail mail messages you send. Importing all your contacts into a Sheets document is just as easy, creating a draft email template in Gmail, and then launching the extension. You can also customize the e-mail content directly from the spreadsheet using markup commands, customize each e-mail to a particular person.

YAMM can be used for 50 emails per day. Paid plans start from $ 28 / year and include scheduled delivery and send up to 400 emails per day.

Hunter: Find Email Addresses

  Hunter Screenshot

Hunter for Google Sheets easily finds email addresses for all domains, then fills your document with its results. Find the professional email addresses of people in a fraction of a second, helping you enrich your database with email. Hunter uses a large number of signals to find the most likely email addresses for someone.

Enter the domain name of the company from which you want to retrieve email addresses, and Hunter adds them all to your Sheets document along with a result that shows how safe they are, and the type.

Hunter is free to use for up to 20 searches per month. Paid accounts range from $ 34 / month to 1000 searches and up to $ 279 per month for 50,000 searches and CSV downloads.


Source link