Integrate People HR with Google Sheets

Send information between People HR and Google Sheets automatically, without writing any code, using Zoho Flow.

Explore prebuilt integration flows to get started

[esc]

Add new employees from People HR to Google Sheets spreadsheets

Maintain a list of your employees on a spreadsheet, without having to manually copy and paste them after adding them to your HR management application. Use this flow to add new employees from People HR to a Google Sheets spreadsheet.

How it works
1. A new employee is added to People HR.
2. Zoho Flow adds the employee to a Google Sheets spreadsheet.
Use this flow
+

Add new employees from People HR to Google Sheets spreadsheets

People HR + Google Sheets

Build your own integrations between People HR and Google Sheets

Connect People HR and Google Sheets with over 900+ apps and build your own integrations using our no-code drag and drop builder and comprehensive workflow elements

Supported triggers and actions

Integrate People HR and Google Sheets using the below triggers and actions

All Triggers - A trigger kickstarts the flow

Employee created

Triggers when a new employee is created

Employee marked as leaver

Triggers when an employee is marked as leaving the company

Row added - Old version

Triggers when a new row is added to the bottom of the selected worksheet. (Will be deprecated soon)

Worksheet created

Triggers when a new worksheet is created in the selected spreadsheet

Spreadsheet created

Triggers when a new spreadsheet is created

Row added - New version

Triggers when a new row is added to the bottom of the selected worksheet

All Actions - Actions are the automated tasks

Add employee

Adds a new employee

Create timesheet

Creates a new timesheet for the specified employee

Create vacancy

Creates a new vacancy

Fetch employee

Fetches the details of an existing employee by ID

Create spreadsheet

Creates a new spreadsheet

Create row - Old version

Creates a new row in the selected worksheet. (Will be deprecated soon)

Create row - New version

Creates a new row in the selected worksheet

Update row - Old version

Updates the specified row in the selected worksheet. (Will be deprecated soon)

Update row - New version

Updates the specified row in the selected worksheet

Fetch row - Old version

Fetches an existing row by the given value. (Will be deprecated soon)

Fetch row - New version

Fetches an existing row by the given value

What is People HR ?

People HR is human resource software that lets you track employee absences, score applicants against different criteria, and discover insights with detailed reports.

HR

What is Google Sheets?

Google Sheets lets you create and edit spreadsheets online. You can collaborate with others, define formulas, and create graphs and charts easily.

Google Popular Spreadsheet

Build comprehensive workflows using

Webhook triggers

Receive your data from a wider range of services in multiple formats, like JSON, form data, and plain text.

Learn more >

Logic

Create customized business workflows by including advanced logic elements like if-then branches, time delays, and more.

Learn more >

Custom functions

Write simple scripting functions to format data, call web APIs, send emails, and more.

Learn more >

We started using both from the beginning, but since swapping [to Zoho], we have automated two full-time jobs and outsourced all sales and support roles. It has been huge and we couldn’t imagine going back Learn more

Owain ap Rees

Sales Director, Artico

Zoho Flow was the main reason we decided in favor of the Zoho platform. An ability to integrate the different parts of the platform is priceless, and we were able to set as many process triggers as we need. Currently, we have eight large flows. They integrate Zoho Books, Zoho Desk, Zoho CRM, and Zoho Cliq in various combinations. Learn more

Louis Castellano

CEO, Lakeside CNC Group

Zoho Flow has revolutionized our integration process, allowing us to transfer data seamlessly across multiple platforms without the need for coding. It has eliminated tedious and time-consuming tasks, making our workflow more efficient and saving us valuable time and effort. Zoho Flow is a game-changer for us, and I highly recommend it to anyone looking to streamline their business processes. Learn more

Toto

Technical Engineer, Master Liveaboards

Watch Zoho Flow in action

Play video

Endless integrations. End to manual work.

SIGN UP TODAY