Skip to main content
Adding Google Sheets to Your Wall

How to import data from Google Sheets to Your Social Wall?

Neira Dzabija avatar
Written by Neira Dzabija
Updated over a week ago

With Walls.io, you can automatically import data from any Google Sheet onto your Wall. It's easy to achieve this with our Zapier integration. This step-by-step guide explains how it's done.
โ€‹
โ€‹๐Ÿšจ Important: This integration requires access to the Walls.io API, which can be purchased as an add-on for all plans. API access is also included in our Enterprise plans and some legacy plans.


1. Sign in to your Google Sheets account

To get started, sign in to your Google Sheets account if you haven't already.

2. Create a new Spreadsheet in your Google Sheets and add new columns & one row below

Create a new spreadsheet in your Google Sheets and remember its name. Then, create columns & one row below them and insert some data there. In the example below, we have created 3 columns: "Name", "Post", "Image", and filled in the row below with the data that we want to import onto the wall๐Ÿ‘‡ Please make sure to insert a direct URL to the image into the row under the Image column.

โ—๏ธPlease note: It's necessary to create only one row (as is shown on the screenshot above) for now in order to establish a proper connection between Google Sheets & Zapier. Add additional rows only after the Zap has been created!


โ€‹

3. Enable API access for your Wall

Log in to your Walls.io account and go to Settings > API and activate the access token: ๐Ÿ‘‡
โ€‹

4. Sign in and Connect Google Sheets

In Zapier, start to create your "Zap" by clicking "Make a Zap" (a Zap is kind of a "recipe" that will connect two apps, in our case Google Sheets and Walls.io). Enter a name for your Zap, i.e. "Google Sheets to Walls.io". Choose Google Sheets for the trigger app and "New Spreadsheet Row" as the trigger event: ๐Ÿ‘‡
โ€‹

Then, choose your Google Sheets account and click "Continue". You'll have to "Sign in to Google Sheets" if this is your first Zap using Google Sheets:๐Ÿ‘‡

5. Choose the Spreadsheet & Worksheet & Trigger Column to watch for new data

Next, set up the trigger by selecting the spreadsheet you've created in step 2๐Ÿ‘‡
Then, select the worksheet you want to import data from and choose any_column for the Trigger Column:๐Ÿ‘‡


โ€‹

Afterwards, click "Test trigger": ๐Ÿ‘‡


โ€‹

and then click "Continue": ๐Ÿ‘‡


โ€‹

6. Choose "Walls.io" for the Action

Next, we're going to set up the Zapier action. Choose Walls.io for the app event and "Create Post" as the Action event:

7. Sign in to Walls.io

Afterwards, connect your Walls.io account this way: ๐Ÿ‘‡
Click "Choose an account" and then, click "Connect a new account"

You'll see a new window where you can insert the API access token of your social Wall. Copy the API access token of your Wall from step 3 and paste it into the Access Token field:

9. Set up the Action

Next, set up the action by selecting appropriate options for the fields, i.e. "Post description" for the Text field, "Name" for the required User Name field, "Image URL" for the Image field๐Ÿ‘‡ If you do not want to show the username on your wall, you can always hide it with a custom CSS snippet, which you can find in this article.


โ€‹

Select "True" for "Moderation Status" if you want to set your wall to Automatic Moderation. If you prefer to have Manual Moderation (=approve each post manually before it gets displayed on your social Wall), select "False".
โ€‹

10. Test your Zap and turn it on

Finally, test your Zap and turn it on:๐Ÿ‘‡


โ€‹
โ€‹

In case you have further questions, don't hesitate to contact the support team via chat or support@walls.io!
โ€‹

Did this answer your question?