In our previous blog post, “
,” we talked about how to create your first Zap. We provided a list of eight popular applications with pre-programmed shortcuts for the installation process.
In this post, we’re going to show you how to connect any of the other hundreds of applications to ChatWork using Zapier. This will entail a few more steps, but if you use our guide below, you’ll become an advanced Zapper and basically a productivity powerhouse!
There’s over 400 apps in
to choose from. We’re going to select Google Sheets for this example.
At ChatWork, our marketing team is located in various offices between San Francisco, Silicon Valley and Tokyo. We use Google Sheets to manage frequently asked support questions and share answers with the global team.
If an answer needs to be researched, it becomes an assigned ChatWork task with a due date.
This post will walk you through how we created a Zap for Google Sheets.
1. Create a Zap
Go to Zapier and from the main navigation bar at the top, click on the first link “Make a Zap.”
Click on the left pull-down menu that says "choose a trigger app." Type "Google Sheets" in the search field.
A new pull-down menu will appear below it called “Choose a trigger.” Open the pull-down menu and select the second option “Updated Spreadsheet Row.”
Now go to the right pull-down menu “Choose an Action app…,” and type “ChatWork” in the search field.
Like before, a new pull-down menu will appear below it. Open it and click “Create task.”
Click the orange “Continue” button. Then click “Connect Google Sheets Account.”
2. Register an Account
A popup will appear with a pre-populated title of “[Your email address’] Google Sheets account.” We recommend renaming it as your name or company’s name like this:
When you click “Continue,” an account authentication page pops open. Choose your Gmail account and click “Accept.”
When you see the message “Account is working,” continue to the next step.
2. Register your ChatWork Account
Now let’s register your ChatWork account. Click the ChatWork icon and add your API key. If you don’t have a ChatWork API key, please see Step #2 in
After you copy and paste your API key, click the “Continue” button.
When you see “Account is working,” you’re ready for the next step.
3. Set the Trigger Information
Select the Google spreadsheet you want to connect with ChatWork. Then choose the tab in the sheet.
From the spreadsheet’s content, select the column title that you will edit on the spreadsheet.
As shown in the example Google sheet below, make sure your spreadsheet has header titles for each column like “Name” and “Question.” You’ll use these headers to pull data into Zapier on the next step.
4. Send to ChatWork
First, decide where you’ll send the spreadsheet information by selecting a Group Chat.Then select the content you want to include in the Task Description.
In ChatWork, there is a tag that can frame the message so it will be easier to view the information.
A final optional step is to select the due date for the task.
Test this new Zap before continuing.
When you see the “Success” message (yeah!), go to ChatWork and check the selected Group Chat for confirmation.
That’s it! You are now an advanced Zapper!!!
We hope this integration example has sparked some ideas how you can combine your most often used applications with ChatWork, save a little time and be more amazing!