Articles tagged "Spreadsheets & databases"

How to track LeadConnector deals in Google Sheets

Discover how to use Zapier's automated workflows to track LeadConnector deals in Google Sheets. Automatically update your spreadsheet with every lead change, so your team stays aligned and ready to act.

How to enter a formula without a function in Excel

Learn how to enter a formula without using a function in Excel, as well as when you might do this and some pro tips for making the process more efficient.

How to send an email when updates are made to Google Sheets rows

Spreadsheets serve many purposes, from organizing budgets and project plans to managing email lists and new leads. Google Sheets already notifies users for spreadsheet changes, but the alerts can be pretty general.

How to make a Gantt chart in Google Sheets

Here's how to use the timeline view in Google Sheets to turn any spreadsheet into a Gantt chart.

How to use IMPORTXML in Google Sheets

Want to import a table or list of info from the web into your spreadsheet? Here's how to do it with Google Sheets' IMPORTXMLimportXML function.

Airtable vs. Trello: Which should you use?

I spent time tinkering with both of these apps, and here, I'll walk you through the differences—and how to know which one is right for you.

How to make a graph or chart in Google Sheets

Google Sheets makes it easy to create charts or graphs out of numbers in your spreadsheet. Here's a step-by-step guide on how to do it.

How to export Airtable to Excel and Google Sheets

Here's how to export Airtable as a CSV file so you can use that data in Excel or Google Sheets.

How to make a pie chart in Google Sheets

Create a pie chart in Excel with our step-by-step guide. From preparing data to customizing and sharing charts, check out our tips for clear data visualization.

How to create Google Calendar events from a Google Sheets spreadsheet

Google Calendar events keep you and your team organized and on track. But creating events on Google Calendar can be tedious when you do it repeatedly. Not to mention, manually entering dates and times can make for human error and inaccurate calendars.