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 requires access to the Walls.io API, which is only included in our Premium subscription & Large event pass.
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 firstname.lastname@example.org!