You can use the MURAL + Zapier integration to automatically send information between Google Sheets and MURAL. The most popular workflow is to create MURAL sticky notes from new rows in Google Sheets, and there are plenty of other workflows to choose from.
Note: If you want to see what else MURAL and Zapier can do together, check out Zapier’s MURAL integration page.
To use this integration, you’ll need an account with:
Note: MURAL reviews all integrations built by partners, but for additional support please reach out directly to Zapier.
How the integration works
Zapier lets you create automated workflows without the need for any coding. Zapier’s automations are called Zaps, which you can set up manually or from a pre-built Zap. Each Zap has one app that triggers the workflow and an app where the action takes place.
With the Google Sheets and Zapier automation, you have two general options:
A Zap takes input from Google Sheets and turns it into output in MURAL: In this case, MURAL will be the app with the action where the data from Google Sheets gets sent automatically.
A Zap takes input from MURAL and turns it into output in Google Sheets: In this case, Google Sheets will be the app with the action where the data from MURAL gets sent automatically.
Note: You can customize the trigger and action in multiple ways. Also, Zapier offers templates based on popular workflows. Feel free to check out the full list of available MURAL + Zapier triggers and actions on Zapier’s MURAL and Google Sheets page.
Create a Zap and use the integration
MURAL’s integration with Zapier is already available to everyone with a MURAL and Zapier account. To create an automation specifically between Google Sheets and MURAL, you’ll make a new Zap with a trigger and an action.
For now, let’s set up a Zap that creates sticky notes in a mural each time a new row is added to your Google Sheet.
Note: If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to work around the issue using these steps.
To create a Zap:
While logged in to Zapier, click Create Zap.
Select Google Sheets as the App Event.
Select New Spreadsheet Row as your Trigger Event.
Choose your Google Sheets account.
If you haven't connected to Google Sheets through Zapier yet, complete the prompted steps to give Zapier access to your Google account.
Set up the Google Sheets trigger in Zapier
Now that you have a snazzy new Zap and Trigger Event, you need to set up the fields that’ll trigger the Zap.
To set up and test a trigger:
In your new Zap, select the Spreadsheet and Worksheet you want to export submissions from.
Click Test trigger.
When you test the trigger, Zapier finds a recent row in your chosen Google Sheet to confirm that the right account is connected and that your trigger behaves as expected. After a successful test, you’ll move on to create an action.
Set up the MURAL action in Zapier
Ready, set, action! This is where you direct the Zap to make sticky notes in your mural from new Google Sheet rows.
To set up and test the MURAL action:
Select MURAL as the App Event.
Select Create Sticky as the Action Event.
Select your MURAL account.
If you haven't connected to MURAL through Zapier yet, complete the prompted steps to give Zapier access to your MURAL account.
Click the Continue button.
Select the Workspace, Room, and Mural where you want the sticky notes added. You can also specify an Area in your mural or the Color, Shape, and position you want for your sticky notes.
Click the Text field and select the information you want added to each sticky note. You can also add your own text for how you want this information to show up on your sticky notes.
Click Test & Review or Test & Continue.
Zapier will let you know that your test was successful. Go check out your mural, and you should see the test sticky note sent directly from your new Zap!
If you don’t love the layout of your test sticky note, go back and update the Text field of your Zap’s MURAL Action. You can add spaces, custom text, or have the information show up as new lines of text in the sticky.
Note: To officially start using your Zap, you must click Turn on Zap. From there, you can choose to have Zapier transfer existing data from the Google Sheet or to start the integration from this point forward.
How do I make a change to an existing Zap?
If you ever want to change this Google Sheets to MURAL Zap, just go to your Zapier dashboard, open your Zap, and make your updates.
I transferred existing data and the sticky notes are all squares. How can I change their shape?
To change the shape of your sticky notes:
Click + drag to select the sticky notes.
Click the Switch type icon in the toolbar.
Select the shape and style you want for your sticky notes.
I transferred existing data and the sticky notes on the mural are all on top of each other! Do I have to move them each one-by-one?
Nope. Here's an easy solution to organize your integration's sticky notes:
(If you want to change the shape of your sticky notes, do that first before doing the following steps to organize your sticky notes into a row, column, or grid.)
Click + drag to select the pile of sticky notes.
Click the Arrange icon in the toolbar.
Select Into a Row, Into a Column, or Into a Grid based on how you want the sticky notes organized on your mural.