Articles tagged "Spreadsheets & databases"

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.

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.

8 strategies for a powerful Notion workspace

In my persistent search for an all-in-one productivity app, I'd be infatuated with shiny new releases, only to find them overly complex or poorly designed. That changed in 2018, when I discovered Notion.

How to automatically save Shopify orders to a Google Sheet

Once you've set up your Shopify store and started taking orders, keeping track of your sales is vital to maintaining a successful business.

How to automatically keep track of your contacts for easier reporting

Whether you're managing leads or newsletter contacts, you've worked hard to earn that contact information. How often do you sit down and analyze it?

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.

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.