Articles tagged "Spreadsheets & databases"

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.

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.

How to add Stripe sales as new rows in Google Sheets

Manually logging Stripe transactions is not only tedious, it's also error-prone. Don't worry, automating your bookkeeping—taking those tasks off your plate while reducing errors—is easy.

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.

4 tips for learning your way around Airtable

Starting a new job is overwhelming. So is learning new software. It's a good thing no one expects you to do both things at once.

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.