Google Sheets Integration

Peasy integrates with Google Sheets to make bulk data entry easier. Instead of typing directly into Peasy's spreadsheet grid, you can work in a familiar Google Sheets environment and import the data when you're ready.

How It Works

1. Open the bulk add tool from Buy > Items or Sell > Catalog (click the table icon in the toolbar).
2. Click Open in Google Sheets at the bottom of the spreadsheet modal.
3. A pre-formatted Google Sheet opens with the correct column headers.
4. Fill in your item data in Google Sheets — you can collaborate with teammates, use formulas, or take your time.
5. When ready, copy the data from Google Sheets and paste it back into Peasy's spreadsheet grid.
6. Click Create items to import.

When to Use Google Sheets

• Collaborating with teammates — Multiple people can fill in data at the same time
• Working with large datasets — Google Sheets handles hundreds of rows comfortably
• Using formulas — Calculate costs, conversions, or other values before importing
• Taking your time — Save your work in Google Sheets and come back to it later

Good to Know

• The Google Sheets template includes the same columns as Peasy's built-in spreadsheet grid.
• Only Item Name and Unit are required — everything else is optional.
• You can also download a CSV template from the same modal if you prefer working in Excel.
• This is a one-way flow — changes in Google Sheets don't automatically sync to Peasy. You paste the data in when you're ready.

Related

• Add Your Items — Adding items to your buy catalog
• Managing Your Catalog — Adding products to your sell catalog