Home Page > Integration > Google Sheets

Google Sheets

Overview

Do you want to reduce the time it takes to track the list of projects in OpenAsset? By using Zapier you can integrate Google Sheets with OpenAsset in countless different ways!

For example, you can:

  • Create a new row in a spreadsheet for every new project created in OpenAsset.
  • Create a new row in a spreadsheet for every new employee created in OpenAsset.

Getting started

It is super simple to get up and running with Zapier integrations, below we outline the steps to get you started.

  1. Use the invite link. Integrations via Zapier are currently invite only so you just need to use the following link and click "Sign Up to Accept Invite" https://zapier.com/developer/invite/99942/654acbd18101216dd5b6e46f1a677e55/
  2. Create a Zapier account. You can create an account for free!
  3. Create an integration. Below are some sample integration you could try out.

Sample integrations

Add a row to Google Sheets for a new OpenAsset project

This Zapier integration will create a new row in Google Sheets every time someone creates a new OpenAsset Project.

https://zapier.com/app/editor/template/32349

It will have a single trigger and action.

Screenshot 2018-12-03 at 16.49.12.png

You'll need to create a spreadsheet with headers that map to the project data you want.

Screenshot 2018-12-03 at 16.38.03.png

 

You can map the project data such as ID, Code and Name to columns in the Google Sheet.

Screenshot 2018-12-03 at 16.38.46.png

 

Remember to make sure it is turned on.

Screenshot 2018-12-03 at 16.39.48.png

 

Here's how the new project data from OpenAsset was displayed in the Google Sheet.

Screenshot 2018-12-03 at 16.39.12.png

 

 

Last modified

Tags

Classifications

This page has no classifications.