Google Sheets

Content, guides, and more for Google Sheets users.

How to Securely Sync ServiceNow Incidents with Google Sheets

This guide will show you how to connect a ServiceNow instance to Google Sheets so you can sync records and spreadsheet rows with a no-code, yet fully configurable workflow. In this tutorial, we’ll demonstrate an […]

The Google Sheets logo, representing a guide to merge cells in Google Sheets.

How to Merge Cells in Google Sheets

Merge cells in Google Sheets to clean up data, clear up your reports, and more. Here are four ways to do it.

An illustration of a robot with a logo for Google Sheets, representing automations.

6 Ways You Can Automate Google Sheets

Google Sheets is a powerful tool for crunching data and building reports, but it can involve a ton of manual work. Here are some ways to automate that.

How To Integrate Google Sheets and Jira

Here’s how easy it is to connect and sync Jira to Google Sheets with Unito’s automated 2-way integration for project managers.

An illustration showing how to create a dropdown list in Google Sheets.

How To Add a Dropdown in Google Sheets

By adding dropdown lists to Google Sheets, you can reduce data entry errors, streamline updates, and more. Here’s how.

How to Easily Integrate Notion and Google Sheets with Automated 2-way Updates

Here’s how anyone can connect and sync Notion to Google Sheets without writing script or code through a 2-way integration.

Logos for Google Ads, Unito, and Google Sheets, representing a Google Ads Budget Pacing Dashboard template.

Free Template: Automated Google Ads Budget Pacing Dashboard for Google Sheets

With this template, you can rely on an automated dashboard to track Google Ads campaign performance and budget.

An illustration of pivot tables in a spreadsheet.

How to Create Pivot Tables in Google Sheets

Want a better way to represent your data in Google Sheets and Excel? Here’s our full guide to using pivot tables.

Featured image illustrating a step-by-step guide on syncing ClickUp to Google Sheets through Unito, depicted by the connected logos through circles and dotted lines.

How to Export and Sync ClickUp Data Into Google Sheets Automatically with 2-Way Updates

Here’s how to automatically export and sync ClickUp tasks into Google Sheets with Unito’s two-way integration for professionals.

Featured image displaying the logos of Google Sheets and Wrike in Unito's guide to setting up a simple Two-Way Sync.

How to Automatically Export and Sync Wrike Tasks to Google Sheets with 2-Way Updates

Here’s how to automatically export Wrike tasks to a report in Google Sheets with Unito’s two-way sync for professionals.

Featured image illustrating a step-by-step guide on syncing one Google Sheets account to another through Unito, depicted by the connected Google Sheets logos through circles and dotted lines.

How to Sync Multiple Google Sheets with Automated 2-Way Updates

Here’s how to set up real-time updates between Google Sheets and another tool through Unito’s 2-way integration.

ʕ•ᴥ•ʔ