10 Best Google Sheets Add-ons to Enhance Output, from Data Scraping to GPT Integration

While Google Sheets is already your reliable helper, sometimes you may wonder if it can help you more. If you are a recruiter, you may want to fill in all the LinkedIn data of the candidates with just a few simple formulas. Or perhaps you heavily rely on ChatGPT for your daily work and wonder if everything could be done directly in Google Sheets, eliminating the need for extra prompts and copy-pasting.

Well, that’s why we all need some powerful Google Sheets add-ons. The right Google Sheets add-ons will boost your productivity and turn your workflow from blah to brilliant in no time.

We’ve selected 10 game-changing Google Sheets add-ons that can help you maximize your efficiency and elevate your work to new heights. Say goodbye to the ordinary and hello to the extraordinary.

Sapiengraph: Best for getting personal and company data from LinkedIn or Crunchbase

Rating: 🌕🌕🌕🌕🌗

Yes, it’s us. Let us explain why we are the best Google Sheets add-on when it comes to getting the personal and company data you want on LinkedIn. First of all, we are compliant with CCPA, GDPR, and SOC 2 regulations. Any LinkedIn data you get with Sapiengraph is legal.

Now you can use Sapiengraph worry-free. Let’s dive deeper into how Sapiengraph can supercharge your work.

Sapiengraph offers custom Google Sheets formulas that help you to get fresh data from public profiles such as LinkedIn and Crunchbase. With the data, you can get information on a person’s work history, education, and so on. It can also do reverse email lookup, so you can find LinkedIn info linked to an email address owner.

With powerful data scraping capability, Sapiengraph is a perfect Google Sheets add-on for recruiters tracking top candidates, public relations people managing contacts of a media list, and sales identifying leads and keeping CRM up-to-date. Sapiengraph also works for VCs to get a list of potential startups and identify the gems to invest in, since it can source companies’ information from Crunchbase.

How to use

First, you need to sign up for a free account and install Sapiengraph’s Google Sheets add-on and extension (see here: why do I need a browser extension). Each account can get 100 free credits.

Then when you open the Google Sheets, go to Extensions -> Sapiengraph -> Launch Sapiengraph. At this point, you may be required to grant permissions to Sapiengraph in Google Sheets. Make sure to check your pop-up blocker.

All is done! Now you can use Sapiengraph’s custom formulas to grab the data you need. For example, if you want to know which school Andy Jassy went to. With his LinkedIn account, we can use this formula:

=SG_PERSON_EDUCATION(“https://www.linkedin.com/in/andy-jassy-8b1615”, "school")

And we now know which school Andy Jassy went to.

Let's try another one. Suppose you're working as an executive search recruiter and you need to identify the CTO at Microsoft. You can utilize this formula:

=SG_LOOKUP_ROLE("cto", "microsoft")

Then you know whom to reach out to.

Pretty easy and convenient, isn't it? For more formulas, you can check the formula document.

Pricing

Sapiengraph’s free plan offers 100 credits and 100 formulas. Each piece of data uses one credit or more, depending on the data you want to scrape.

If you run out of credit or want more formulas, you need to subscribe to an annual plan. The first tier plan, Lite, starts at $49 per month. Lite offers 12,500 credits and 12,500 formulas per month if you choose to be billed monthly, and 175,000 credits per month if you choose to be billed annually.

ProjectSheet Planning: Best for project management

Rating: 🌕🌕🌕🌗

We usually turn to some project management application or software to handle team tasks and projects. But a powerful Google Sheets add-on can achieve the same, likely at a lower cost.

ProjectSheet Planning is a Google Sheets add-on provided by forScale. This add-on allows you to break down, track, and manage tasks in a project. Its Gantt chart visually represents task progression, allowing users to oversee the progress of all tasks at one glance. This Google Sheets add-on is ideal for project managers who need to collaborate with several teams and stakeholders. It is also perfect for marketing professionals who have multiple marketing tasks to chip away at the same time.

How to use

After installing the ProjectSheet Planning, go to Extensions -> ProjectSheet Planning -> Add ProjectSheet add-on. It will automatically create two tabs, one is “Project Summary”, and the other is “Task Schedule”.

While “Project Summary” is mainly for overviewing the project only, “Task Schedule” is where task management occurs. You can input the task name, start date, and finish date. The Gantt bar against the time scale will show up when the start date and finish date are filled in.

When you change the percentage of progress, the marks on the Gantt bar will change accordingly, giving you an idea of how much effort you might need to put into the task for the rest of the days to meet the deadline.

On the sidebar, you can manage the hierarchy of the tasks, by increasing or decreasing the indent of selected tasks. You can also expand or collapse the tasks, or hide completed tasks to have a cleaner view of all the tasks.

Pricing

The free version of ProjectSheet Planning offers one day as a unit. The paid version allows you to change the Gantt timescale from days to weeks, months, or years.

Some other features of the paid version include linking successive tasks to get the project finish date and assigning resources to tasks to calculate costs. The paid version costs €15 for one year. Yes, way cheaper than most of the task management applications and software.

GPT for Sheets™ and Doc™: Best for ChatGPT integration

Rating: 🌕🌕🌕🌕🌗

Let's face it, most of us rely on ChatGPT to some extent in our daily work routines. Rather than repeatedly copying and pasting, you can seamlessly integrate ChatGPT into your workflow using GPT for Sheets™ and Doc™, a Google Sheets add-on designed for those who heavily depend on ChatGPT.

GPT for Sheets™ and Doc™ is compatible with OpenAI GPT-3.5 and GPT-4. It enables you to perform a variety of tasks such as writing, editing, translating, listing, and extracting, among others.

For instance, if you work as a social media specialist and maintain a Google Sheets content calendar to track all posts across various social media platforms, you can use the writing and editing functions directly within Google Sheets. You can even effortlessly organize your output into tables, rows, or columns, with the formulas provided by GPT for Sheets™ to boost your work efficiency.

How to use

As this article centers on Google Sheets add-ons, we will only cover how to utilize this add-on within Google Sheets. First, install the add-on from here, then navigate to Google Sheets -> Extensions -> GPT for Sheets™ and Doc™ -> Open.

Next, you can input your prompt along with formulas. For instance, let's say we want to generate some catchy taglines for ice cream advertisements. You can achieve this by using the following formula:

=GPT_LIST("Give me 5 good short ads about ice cream.")

With the formula, the 5 taglines will show in the column.

We find them still too long for our advertisement. We can use this formula to shorten them.

=GPT_EDIT (input, "shorten the sentences into no more than 50 characters")

No more copy and paste. Everything you need is on the Google Sheets.

The above is just an example. GPT for Sheets™ and Doc™ offers a full guide on the formulas that you can try and test around.

Pricing

GPT for Sheets™ provides a free account that allows you to generate up to the first 100,000 words using GPT-3.5. If you require more words or wish to integrate different models, you can choose from various packs tailored to your needs. The most affordable pack is priced at $19, with word limits varying based on the selected models.

Autocrat: Best for merging Google Sheets data into different document formats

Rating: 🌕🌕🌕🌕

Imagine you are a teacher who needs to create and print out certificates for 50 students, or an event organizer who is sending gala dinner invitations to 100 VIPs, what would you do? Type the name on the certificate or invitations one by one? Autocrat is your best friend here.

With Autocrat, users can effortlessly take out the data from Google Sheets and merge it into a template document, such as PDF or Google Slides. This feature automates the repetitive work, making personalizing documents such as certificates, invoices, or letters easy.

How to use

Let’s try to merge different names in a Google Slides template. We have one Google Spreadsheet with all the names and a Google Slides template that we want to have each name in respectively. Remember to use << Name >> so that the names on Google Sheets can be merged into the template.

You can install Autocrat here. Once installed, go to Google Sheets -> Extensions -> Autocrat -> Launch. Click “new job” and give it a name to start the work.

Choose the Google Slides template we’ve created. Then we can map the source data in Google Sheets to the Google Slides template.

The output will be new files, you need to name the files. You can use << name >> for customized file names. Then choose where you want to store the files.

You can also choose if the files can be edited or viewed only. If you need to send the files, you can customize the email as well. But in our example, we will skip this.

It has the trigger feature to automatically create new ones if the list in the Google Sheets will be added in the future.

Now all is done! Click run the job.

You can see all the customized slides are in the folders. In the Google Sheets, there are links to each file too.

Pricing

AutoCrat is completely free. However, as it’s a Google Sheets add-on leveraging Google’s platform, pay attention to the limitations of the Google plan you are using, such as email recipient amount per day.

Form Mule: Best for mail merge

Rating: 🌕🌕🌕🌕🌗

While AutoCrat excels at merging data from spreadsheets into various document formats, Form Mule is a Google Sheets add-on specifically designed for mail merge tasks. If you don't have to send additional Google documents or PDF files, Form Mule proves to be more convenient. With Form Mule, you can send personalized emails using information from a Google Sheet in bulk or trigger them upon submission of a Google Form.

Moreover, you can create up to 10 email templates with different conditions. This feature proves invaluable for administrators who need to send reminder emails upon form submission or marketing professionals who need to distribute different coupon codes based on survey completions.

How to use

You can install this Google Sheets add-on here, and go to Google Sheets -> Extensions -> form Mule -> Open.

We created a Google form for demonstration, as shown below.

When you open Form Mule, the first step is to select the source data and trigger. Setting the trigger is optional, but please note that it can only be set if the source data is from a Google Form response.

The next step is to create an email template. Form Mule enables you to have up to 10 email templates for various conditions. In this example, we created two templates based on the response regarding lunch preferences.

Simply click on the tags on the right-hand side, and the variables will be set accordingly.

After setting up the template, go to preview to ensure the email is exactly as you expected.

Once everything looks good, you can send them out and you're all set! Additionally, in Google Sheets, you can monitor the sending status.

Since we've set the trigger upon form submission, emails will be automatically sent out whenever new responses are received. You can simply check back occasionally to track them. This will free you from the repetitive task of checking and sending emails.

Pricing

Form Mule does not offer pricing information, leaving it unclear if it is entirely free. However, like AutoCrat, Form Mule depends on Google's platform, which means there are limitations on the amount of sent email based on your Google Workspace plan.

Unito: Best for app integrations

Rating: 🌕🌕🌕🌕

Picture yourself as a design team leader. Every time a new design task comes in, you find yourself having to scroll through Trello board or message your team members to see who can take the work. Or you are a paid advertising professional. Each Monday, you go to Facebook Ads and Google Ads platforms to download the report one by one and copy and paste the data into your reports. It's a tedious process, isn't it?

This is where Unito comes in. Unito is a Google Sheets add-on that can integrate Google Sheets with over 40 applications, including marketing tools such as Google Ads, Facebook Ads Manager, and project management tools such as Asana and Trello. Unito automates the process of updating data from these platforms directly into your Google Sheets. This automation helps eliminate the hassle of manual data gathering and cleaning when compiling your reports.

How to use

Let’s say you're in charge of a team of designers, and tasks are coming in from all corners of the company. It can be pretty challenging to manage everyone’s workloads, right? Let's simplify things by connecting Trello boards with Google Sheets. This way, you can easily see what everyone is working on with just a glance.

First, you need to sign up for a Unito account and install the add-on from here. Then navigate to Google Sheets -> Extensions -> Open Unito. Before starting to integrate, make sure the first row contains distinct and descriptive names for your columns, and also click the “Add 2 columns” button when it pops up. This will add the required columns that Unito will fill once the flow is launched.

Now you can create a new flow. Connect the two tools. Note that it can be synced in two ways, so if you make any change in the Google Sheets, it will be changed in Trello too.

You can choose what values will be updated when there’s a change, and what data/information you want to track in the spreadsheet.

And you’re all set. Launch the flow and you can see all the information you need in the Google Sheets. Adding conditional formatting, we can see the current workloads clearly.

Pricing

Unito gives you a 14-day free trial to try it out. The Basic plan starts at $99 per month. With this plan, you can connect one tool and sync up to 1,250 items. The price will go up If you need to sync more items.

Supermetrics: Best for marketing data integration and report

Rating: 🌕🌕🌕🌕🌗

While Unito can integrate digital marketing tools such as Facebook Ads and Google Ads, its standout feature lies in its seamless integration with project management tools. If you are a digital marketing professional who focuses on marketing data analytics and managing many different digital marketing platforms, such as TikTok, Amazon, and Pinterest, Supermetrics may be more suitable for you.

Supermetrics provides a Google Sheets add-on that can connected with a wide array of digital marketing tools. From LinkedIn Ads, Pinterest Ads, and Reddit Ads to LINE Ads (in case you are unfamiliar, LINE is a messaging app that is popular in Japan, Taiwan, and Thailand). But what sets Supermetrics apart is it offers extensive collections of reporting templates for its Google Sheets add-on. You don’t need to build a report from scratch.

How to use

You can install Supermetrics’ Google Sheets add-on here, and go to Google Sheets -> Extensions -> Supermetrics -> Launch. And it will provide you with a template gallery you can choose from.

Select the one you need, and connect the marketing tools you need for the report. The data will automatically be pulled into the Google Sheets template. Yes, that’s all.

Building a Google Sheets data report from scratch and importing the data you need can take several hours. But with Supermetrics and its template, you can have it within a few minutes.

Pricing

Supermetrics’ Essential plan starts at $29 per month, billed annually. It offers 4 data sources: Facebook ads, Google ads, Google Analytics and GA4. If you require additional data sources beyond those provided in the plan, you can add each for $19 per month.

Table Styles

Rating: 🌕🌕🌕🌕

You might think Google Sheets has everything you need to make a pretty table. You can change the font, font size, color, alignment, number formats, border, and so on. But have you ever noticed that they are everywhere in Google Sheets? It’s almost like a treasure hunt to get everything you need to style a table. If you are making multiple tables with varying row and column counts, you cannot copy and paste the style either. You need to go back to square one every time.

Table Styles is the perfect Google Sheets add-on for your needs. If you find yourself creating numerous tables for a report, Table Styles simplifies the process by allowing you to style all your tables with just one click. This not only saves you time but also liberates you from the tedious task of repetitive formatting.

How to use

After installing Table Styles, go to Google Sheets -> Extensions -> Table Styles -> Start. There are over 30 templates available. But of course, you can create your own too.

Let’s try to style the table from the template, with some customization. Don’t look too closely at the data. It’s just fake data we used GPT for Sheets™ and Doc™ to generate.

Since we don’t have a footer and right column, we just deselect them.

Then we can customize the alignment, font, and all other styles we want to make.

We may have more tables to make for this report, so we can save it as a template for the next one. Select the table range, and all is set.

We can use the same style for different tables in the future with just one click!

Pricing

Table Styles offers a 30-day free trial. During the free trial, you can convert to a one-year subscription at $9.99. You can also opt for the lifetime plan, which costs 39.95.

Powerful Tools: best for reducing repeated work

Rating: 🌕🌕🌕🌕🌗

We know that we can use numerous formulas in Google Sheets to help us change text cases, split text, count, and sum by colors, to name just a few. But let’s be honest, most of the time we don’t remember the formulas, so we need to either Google them again or check our bookmarks. Even for those proficient in Google Sheets formulas, achieving the desired results can sometimes require lengthy formula strings to meet specific conditions.

Powerful Tools is the perfect Google Sheets add-on to save you from the complexities of these formulas. With just one click, you can merge data, eliminate duplicates, and perform various other tasks effortlessly.

How to use

You can install Powerful Tools here, and go to Google Sheets -> Extensions -> Powerful Tools -> Start. Use the sidebar to find the ones that can help your work.

For example, we want to only keep the flavor of the ice cream to make the table clean. Go to split, and split the text “ice cream”.

Or the raw data is a mess and there are some empty rows, we can also just delete all the empty rows with one button.

These are just a few basic examples. There are many more functions you can discover to make your Google Sheets neat and easy to read, all without having to write long formulas.

Pricing

Powerful Tools offers a 30-day free trial. During the free trial, you can convert to a one-year subscription at $29.95. They also offer a lifetime plan, which costs $99.95.

Wolfram|Alpha: best for pulling fact data into a report

Rating: 🌕🌕🌕🌕

Wolfram|Alpha is a powerful computational knowledge engine that can be used to answer a wide range of questions with real data. They have a Google Sheets add-on that you can just pull the data directly into Google Sheets. For example, if you're making a report about the GDP of different countries, instead of searching for each one separately, copying and pasting the data to Google Sheets, you can do it all in one place without switching between tabs.

How to use

After installing Wolfram|Alpha’s Google Sheets add-on, Google Sheets -> Extensions -> Wolfram|Alpha, and you can choose to open Wolfram|Alpha sidebar or compute selection with Wolfram|Alpha.

Let’s try to compute selection with Wolfram|Alpha first. We can type “GDP of USA” in the cell, select it, and compute selection with Wolfram|Alpha.

The data comes out automatically.

You can also use Wolfram|Alpha’s sidebar to do the same thing. Type the things you want to know, and the sidebar will show the answer and data you need. This function allows you to check the data and sources instead of just getting the answers. You can click insert as plain text or image to the spreadsheet.

Pricing

Wolfram|Alpha’s Google Sheets add-on is completely free.

Work Smart, Not Hard

Success at work isn't just about working hard; it's also about working smart. Utilizing Google Sheets add-ons into your workflow can significantly maximize output while minimizing unnecessary effort. Try the Google Sheets add-ons we’ve introduced above to boost your work efficiency. They're a great way to work smarter and achieve our goals without burning ourselves out!

For further assistance or inquiries:

• Email us at [email protected]
• Chat with us directly via our homepage