Articles tagged "Spreadsheets & databases"

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.

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 send form and ticket information to a spreadsheet for better analysis

Need to identify trends among survey or form responses? The quick and easy way is to analyze their information and interactions in a spreadsheet. The hard part: getting that information in one place. 

How to automatically log information from websites

When you hear the word "log," you might think of meticulously copying and pasting items into a spreadsheet or document. Who has the time or energy to maintain that?

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.