Articles tagged "Spreadsheets & databases"

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 automate a weekly Wordle competition for friends

See how a Zapier employee created a friendly Wordle competition using email and Google Sheets.

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.

The only thing better than a spreadsheet is a spreadsheet with Wordle in it

As a part-time spreadsheet artist, I wanted to see if Wordle could be adapted to my medium of choice: Google Sheets. And here's the result: SHEETLE!

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?

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.

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.