Articles tagged "Spreadsheets & databases"

How to create new Softr users from Airtable

If you need to regularly add new users to Softr, your fast-moving processes can start to bog down. Fortunately, with Zapier's automated workflows, you can automatically create new Softr users every time a new row is added to an Airtable base.

5 ways to automate SQL Server with Zapier

When you pair SQL Server with automation, you can enhance your data management, improve efficiency, and ensure your team always has access to the latest information. Here's how.

4 ways to automate PostgreSQL with Zapier

With Zapier, you can effortlessly link PostgreSQL with thousands of other apps and services, automating data transfers and optimizing your workflows.

How to automatically copy rows between Excel spreadsheets

With automation, you can connect two Microsoft Excel spreadsheets, so as soon as you add a row to one, it automatically copies over to the second. Here's how.

Why you should ditch spreadsheets for Tables

Ready to make your spreadsheet more actionable? See why you should switch to tables instead.

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 use Excel: A beginner's guide

Here's everything you need to know to create and use spreadsheets in Microsoft Excel.

How to use conditional formatting in Google Sheets

Here's how to apply conditional formatting in Google Sheets to make key data stand out.

How to make a table in Google Sheets

Here's how to create a table in Google Sheets using your existing data or from a pre-built template.

How to remove duplicates in Excel

Here's how to find and remove duplicates in Excel.