Connect a Google sheet & sync Client Gallery orders

You can now connect Client Galleries with a Google Sheet so that all the orders data gets synced to the sheet. Vist your Client Galleries settings and connect your account as suggested below.

To connect a Google Sheet, follow these steps:

  • Enter settings (1) in the Search Bar.
  • From the related results, click on the Client Galleries – Sell Images – Settings (2) under Studio Links. 

 

  • You will now reach the Settings page.
  • Scroll down to the Store notifications section.
  • Then, click on the Connect Google Sheets button (3).

  • You will see a new window wherein you will have to sign in to your Google account.
  • Next up, click on the Continue button to give permission to the Pixpa Data Export.

  • Your Gmail account will now be connected to the Client Galleries. You can click on the Disconnect button to remove the connection.

 

  • Next up, enter the new Spreadsheet name and hit the Save button.

  • Voila! You have successfully connected your account to your store.
  • You will now see a new spreadsheet (with the name that you have specified above) in your Google Sheets.
  • As you start receiving orders, the extracted data will be synced automatically to the Sheet and the data would be shown as below:

Can't find what you're looking for?

Get in touch with a Pixpa Expert.