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.
Contents
FAQ.
Prerequisites
To use this integration, you’ll need a:
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:
From your Zapier dashboard, click Create Zap.
Type a name for your Zap in the top left of the screen.
Press Enter or Return.
Set up the Google Sheets trigger in Zapier
It's time to set up the trigger for your new Zap. Each Zap has one app that triggers the workflow and an app where the action takes place. So, the trigger is where you'll set up the connection with Google Sheets.
Here's what you'll do to set up your new Zap's trigger:
Set up trigger app and event.
Connect your Google Sheets account.
Set up and test trigger.
Click a step to see more details:
Step 1 (Trigger): Set up trigger app and event.
Step 1 (Trigger): Set up trigger app and event.
The first part of the Trigger section is where you'll select your trigger app and event. In the case of the Google Sheets and Mural automation, Google Sheets will be the app that triggers the Zap.
To set up the App & event section of your Zap's trigger:
In the App & event section of your trigger, select Google Sheets as the App.
Select your Event.
New Spreadsheet Row - Triggers when a new row is added to the bottom of a spreadsheet.
New Spreadsheet - Triggers when you create a new spreadsheet.
New or Updated Spreadsheet Row - Triggers when a new row is added or modified in a spreadsheet.
New Worksheet - Triggers when you create a new worksheet in a spreadsheet.
Click Continue.
Step 2 (Trigger): Connect your Google Sheets account.
Step 2 (Trigger): Connect your Google Sheets account.
You must connect the Zap to your Google account to ensure it pulls responses from the correct spreadsheet in Google.
To set up the Account section of your Zap's trigger:
In the Account section of your trigger, select 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.
Click Continue.
Step 3 (Trigger): Set up and test trigger.
Step 3 (Trigger): Set up and test trigger.
Now that you have your Zap connected to a trigger app (Google Sheets) and your Google account, you'll specify which Google spreadsheet will trigger the Zap.
To set up the Trigger section of your Zap's trigger:
In the Trigger section of your Zap trigger, select the Spreadsheet and Worksheet you want to export rows from.
Click Continue.
Click Test trigger.
Upon a successful test, you'll see a message that says, "We found a spreadsheet row!"
Click Continue.
When you test the trigger, Zapier tries to finds the newest row in the spreadsheet you specified. The test confirms that the right Google Sheets 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! An action is an event a Zap performs after it's been triggered. The action in this case is that you want Mural to create sticky notes in your mural (action) directly from Google Sheets row (trigger).
Here's what you'll do to set up your new Zap's action:
Set up action app and event.
Connect your Mural account.
Set up and test action.
Click a step to see more details:
Step 1 (Action): Set up app and event.
Step 1 (Action): Set up app and event.
The first part of the Action section is where you'll select your action app and event. In the case of the Google Sheets and Mural automation, Mural will be the app with the action.
In the App & event section of your Zap's action, select Mural as the App.
Select Create Sticky as the Event.
Click Continue.
Step 2 (Action): Connect your Mural account.
Step 2 (Action): Connect your Mural account.
You must connect the Zap action to your Mural account to ensure the sticky notes land in the correct mural.
To set up the Account section of your Zap's action:
In the Account section of your Zap's action, 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 Continue.
Step 3 (Action): Set up and test action.
Step 3 (Action): Set up and test action.
Now that you have your Zap action connected to an app (Mural) and your Mural account, you'll specify which mural will receive the sticky notes.
To set up the Action section of your Zap's action:
Select the Workspace, Room, and Mural where you want the sticky notes added.
(Optional) 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 referred to.
Note: The Text options will match the column names of your chosen Google spreadsheet.
Click Continue.
Click Test action.
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!
To officially start using your Zap, you must click the Publish Zap button. From there, you can choose to have Zapier transfer existing data from the Google spreadsheet or to start the integration from this point forward.
Note: 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.
FAQ (frequently asked questions)
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:
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 fix using Mural's Arrange function:
Click + drag to select the pile of sticky notes.
Click the Arrange icon in the toolbar.
Select how you want the sticky notes organized. (We recommend In a Grid.)
