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.

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

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!

​

Log in to your Walls.io account and go to Settings > API and activate the access token: 👇
​

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:👇

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": 👇

​

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

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:

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".
​

Finally, test your Zap and turn it on:👇

​
​