Google Sheets

How to connect your Google Sheets Feed to Wherehouse

Published on:

Follow the guide below to connect your Google sheets data feed to Wherehouse.

Steps on Wherehouse 👨‍💻

 
Google Sheets
1️⃣  On the Wherehouse dashboard, within the subscription you’d like to authorize, select Feeds from the sidebar.
 
Google Sheets
2️⃣  Look for the Google Sheets connector(s).
3️⃣ Click Authorize
This will take you to a modal asking for the following:
Sheet Name
File ID
More on how to find these below.
 

Steps on Google sheets 📊

Google Sheets
1️⃣ Open the Google Sheet that you want to connect to Wherehouse
 
Google Sheets
2️⃣ Select
“File” - “Share” - “Share with others”
 
Google Sheets
2️⃣ Share the sheet with the following mail address:
wherehouse@prime-plating-314814.iam.gserviceaccount.com
❗
Be sure to select the “editor” permission
 
 
3️⃣  To find the File ID click the URL bar in your browser
Google Sheets
❗
Your browser needs to be open on the sheet that you need to connect.
4️⃣  Copy the code that follows after spreadsheeds/d/ and before /edit#
5️⃣  Paste it into the required field on the Wherehouse dashboard.
Google Sheets
6️⃣ Copy the Sheet Name
7️⃣ Paste it into the required field on the Wherehouse dashboard.
❗
Please note it is case sensitive so copy & paste would work best
 

Steps on Wherehouse (continued) 👨‍💻

Google Sheets
1️⃣ If you’ve pasted the required info into the modal on Wherehouse, hit save
 
Google Sheets
 
2️⃣ If all went well you should see “Successfully authorized connector”.