Connect Google Sheets and Kintone to unlock the power of automation
- No credit card required
- Free forever for core features
- 14-day trial for premium features and apps
Set up your first integration
Quickly connect Google Sheets to Kintone with a Zapier template.
Our most popular template
How Zapier works
Zapier makes it easy to integrate Google Sheets with Kintone - no code necessary. See how you can get setup in minutes.
Choose a trigger
A trigger is the event that starts your Zap—like a "New Spreadsheet Row (Team Drive)" from Google Sheets.
Add your action
An action happens after the trigger—such as "Add Comment" in Kintone.
You’re connected!
Zapier seamlessly connects Google Sheets and Kintone, automating your workflow.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023




93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Frequently Asked Questions about Google Sheets + Kintone integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Sheets and Kintone
How can I set up a trigger in Google Sheets to update Kintone records?
To establish a trigger in Google Sheets for updating records in Kintone, you need to use our automation tool to monitor changes in your selected spreadsheet. When specific cells or rows are modified, our platform will automatically update the corresponding records in Kintone based on the mapping you configure.
What actions can be performed in Kintone from Google Sheets using our integration?
Through our integration, you can perform actions such as creating new records, updating existing ones, or deleting entries in Kintone directly from Google Sheets. These actions can be customized based on your workflow requirements.
Can we automatically add new rows from Google Sheets to a Kintone app?
Yes, by setting up an automated workflow, whenever a new row is added to your specified Google Sheet, it's instantly created as a new record in your chosen Kintone app without any manual effort.
Is it possible to pull data from Kintone into Google Sheets on a schedule?
Absolutely. Our integration allows you to schedule data extraction from Kintone into Google Sheets at regular intervals. This ensures that your spreadsheets are always up-to-date with the latest information.
How can we handle errors when syncing data between Google Sheets and Kintone?
We provide detailed error logging and notifications so that if something goes wrong during the sync process between Google Sheets and Kintone, you'll receive immediate alerts along with troubleshooting details to resolve the issue swiftly.
Does changing a record in Kintone update linked cells in Google Sheets automatically?
Yes. When you set up a bi-directional sync between Google Sheets and Kintone through our integration, any changes made in either platform can automatically reflect on the other, ensuring consistency across both systems.
Are there any limitations on the types of data that can be synced between Google Sheets and Kintone?
While most standard data types such as text, numbers, and dates are fully supported by our integration between Google Sheets and Kintone, complex fields like attachments or images may require additional configurations or might not be supported directly at this time.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerPolling- Drive
Try ItTriggerPolling- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerInstant- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column_nameRequired
- Index
ActionWrite
- No_team_drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerInstant- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Try ItTriggerPolling- Drive
- SpreadsheetRequired
Try ItTriggerPolling- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
ActionWrite