Articles tagged "Spreadsheets & databases"

Collecting complex data? Here's how to automate it with Zapier

Whenever you need to handle complex information, such as payment information or signatures, a data collection tool will get the job done better than traditional form builders.

Spreadsheets aren't databases—stop using them like one

Sometimes a spreadsheet isn't enough. Sure, they're quick to create, but they have limits—and those limits have consequences.

How Zapier helped turn this roofing company into a million-dollar business

There's a point in the life cycle of every contracting business when you reach a plateau. It happened to me and my roofing business not long ago.

The Zapier guide to line items

What exactly is a line item? If you’ve ever received a receipt for a purchase, or filled out an invoice, you’ve already seen them: A line that includes each product’s name, price, or quantity, repeated for every product.

Why you should use Google Sheets as your browser homepage

In the before-times, when I shared an office with other people, I used to be jealous of the "new tab" screens and plugins that my coworkers had. Every time they opened a new window, there'd be a calendar, a to-do list, or a picture of their cat/dog/turtle.

What is data validation in Google Sheets? 

Spreadsheets are anarchy. You can type whatever you want in any cell and no one can stop you. I could write "orange" in a column labeled "birthday" and no one could stop me. Like most freedom, this is great until you make a mess.

How to get started with data collection and analytics at your business

Using data well can have a huge impact on your bottom line. But with the increasing numbers of specialized products we're using to run our businesses, it's not easy to collect and keep track of all that data.

A simple client database template for freelancers

I've tried a bunch of CRMs in my day—I run a content marketing business and have 35 active clients, so it's crucial that I have an easy spot to manage my client information. But none of the apps I tried fit the bill.

Google Tables vs. Google Sheets: What's the difference?

To summarize: Google Sheets is a spreadsheet, while Google Tables is a database with built-in automation tools. Let's talk more about what that means.

How a one-woman nonprofit scaled to deliver thousands of meals to people in need

At the beginning of the pandemic, Rhiannon Menn was feeling helpless. She was looking for a way to support the families in her community while still following stay-at-home orders and keeping her family safe.