Skip to content
ShopiAgents

Save to Google Drive and Sheets

Keep signed terms, quotes, statements and buyers' PO files in Google Drive, keep orders and buyers in Google Sheets, and read orders from a sheet.

If your team lives in Google Drive, your wholesale paperwork can land there too. Signed terms, accepted quotes, statements and the PO files buyers send are saved to Drive as they happen. Orders, buyers, money owed and standing orders stay up to date in a Google Sheet. And a sheet you or a buyer fill in can become an order.

Plan: every plan. Who can do it: Admins set it up. Editors and up can pick files from Drive when they add an order.

Before you start

  • Connect Google Workspace in Integrations → Google Workspace, signed in with the account your orders arrive in. When Google asks, tick every box, including Google Drive. See Connect Google Workspace.
  • To pick your own folders and sheets, add your Google app's API key and project number in the Google Workspace settings. Without them, everything goes to the app's own folder and sheet in your Drive.

The app only sees files it makes or you pick. It never reads the rest of your Drive.

Save documents to Drive

  1. Go to Integrations → Google Workspace and scroll to Save documents to Google Drive.
  2. Switch on what you want kept:
    • Signed terms: the PDF a buyer accepted, with a record of who, when and how.
    • Accepted quotes: the quote PDF, when a buyer accepts it.
    • Statements: each statement sent to a buyer.
    • Files buyers send: purchase orders and other files that come with an order (PDF, Excel, photos).
  3. Each one goes to the app's folder (for example Wholesale / Quotes), or click Choose folder to pick one of yours. Use the app's folder switches back.
  4. Switch on A folder for each buyer to file them by buyer.

A copy is saved each time it happens, from now on. Open the app's folder in Drive takes you there, and Saved to Drive lately lists the last files.

<!-- screenshot: connections/google-drive-and-sheets-1.png — Integrations → Google Workspace, Save documents to Google Drive card with Signed terms and Accepted quotes on -->

Keep lists in Google Sheets

  1. Under Keep lists in Google Sheets, switch on a list: Orders, Buyers, Money owed or Standing orders. Each list gets its own tab.
  2. Use the app's sheet (Wholesale lists), or click Choose sheet to pick one of yours.
  3. For Orders, choose how:
    • The whole list, updated every hour: the Orders tab is rewritten with every order.
    • A new row for each approved order: added the moment you approve; rows already there stay as they are.

Lists update every hour. Click Update now to update them straight away, and Open sheet to see it.

Read orders from a Google Sheet

  1. Under Read orders from a Google Sheet, click Choose sheet and pick the sheet where you or a buyer add order lines.
  2. Switch on Watch this sheet for new orders.

Every 15 minutes, new rows come to Orders as one order, read like an uploaded file and checked at the buyer's prices. Rows already in the sheet are left alone, and nothing is approved without you.

Pick a file from Drive when you add an order

On Orders → Add order, under the file drop area, click Choose from Google Drive to pick a buyer's PO straight from your Drive.

<!-- screenshot: connections/google-drive-and-sheets-2.png — Google's file picker opened from Add order -->

What your buyers see

Nothing changes for them. Files are saved in your Drive, not shared with buyers.

Good to know

  • Switches apply at once. Nothing is saved or read until you switch a rule on.
  • Turning a rule off stops new copies. Files and sheets already in your Drive stay there.
  • If you disconnect Google Workspace, saving to Drive and Sheets stops. Your files stay in Drive.

If something goes wrong

  • "Google Drive and Sheets aren't turned on for this connection yet": click Sign in again with Google and tick Google Drive when Google asks.
  • No Choose folder or Choose sheet buttons: add your Google app's API key and project number in the Google Workspace settings.
  • "Last Google Drive run didn't finish": the message under it says why. If you deleted or moved a folder or sheet you chose, choose it again or switch back to the app's own.

More in Email and Google Workspace problems.

Still stuck? Email support@shopiagents.com and a person will help.