Integration with Google Sheets

[Raymond G.]

Hello, I am researching ways RMP can help my company process the various customer services surveys we receive. We are in the process of moving our survey responses into Google Sheets.

My question--is it possible to for RMP to:

1) pull information from a a given row in a Google Sheet
2) permit editing of the information within said row (possibly through a web form)
3) and allow a user to send this information out (be it to our website or elsewhere)

For example, a guest would respond to a survey, the information would be transferred to a Google Sheet, and then an employee could view/edit this information before triggering a email response to other departments. I've built an app that automatically writes information into a Google Sheet, but didn't know if this additional functionality is possible.

Thank you in advance for any assistance you can provide, and please let me know if further information is required.

[Pankaj Kumar]

Hi,

The scenario you discussed can be easily build up in RMP. Please find my comment below.

1) pull information from a a given row in a Google Sheet

Yes, you can use the "Get rows matching a criteria" connector.

2) permit editing of the information within said row (possibly through a web form)

you can get the info from the Google Sheet, display it in Web Interface, after users update in WI, update the sheet using connector "Update a list row" or "Update a row".

3) The information would be transferred to a Google Sheet, and then an employee could view/edit this information before triggering a email response to other departments.

yes, it can be done in the process. After google sheet is updated, in a manual activity this check (view/edit) will be done before triggering a email response to other departments.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/bb1c671d-e9da-435b-8873-2169b2c81f92%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[Raymond G.]

Thank you Pankaj! I was able to set up the connectors fairly easily.

I think where I am having trouble is configuring a process to monitor the spreadsheet where information is written, and automatically add it to our web interface where editing and emailing can take place. I have experience creating a web interface in RMP, but I need some guidance on how to have this process triggered by a new row being added in a spreadsheet.

Is there a tutorial you can point me in the direction of?

[Pankaj Kumar]

Hi Raymond,

Please correct me if I misunderstood.

1. You want to monitor the changes in spreadsheet

2. if any change occur in spreadsheet, that info should be displayed in a Web Interface.

3. From the WI, info can be edited and mailed.

I have few query here:-

1. Does spreadsheet is modified manually or by some process/activity.

2. Does specific rows of the spreadsheet will be modified or any row.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/0123654c-0032-4e8a-9071-0359275cbae1%40runmyprocess.com.

[Raymond G.]

Let me clarify:

1) A user submits a survey and the data is loaded into a Google Sheet as a new row (this is outside of RMP)
2) Using RMP, this data is imported using the "retrieve rows" connector from Google
3) That data is loaded into a web interface where editing can occur, and different department can be notified/emailed from within the interface.

So far I have been able to successfully import the data into RMP, but I cannot get RMP output that data correctly.

I followed the Tech Tuesday tutorial here: https://www.youtube.com/watch?v=of2rMOoJZdw if that helps. I can also share the process and access to the test Google Sheet I'm using if you think that would help.

[Pankaj Kumar]

Hi Raymond,

I will work on your requirement, and will update you on the same. I have just one quick question for you, how you are retrieving the newly added row in RMP so I will start from this.

Thank You, 
Pankaj Kumar

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/45568f19-af53-406a-8f11-1deb79384e7c%40runmyprocess.com.

[Raymond G.]

Pankaj, I'm using the Google Spreadsheet connector "retrieve all rows". Ultimately we would like the only new rows (for new incoming surveys) to be imported and sent to the web interface, which is where the editing and emailing to other departments would occur.

Thanks again for your help!

[Pankaj Kumar]

Hi Raymond,

Once you received the worksheet data using the"Get all rows [v3]" connector, you can retrieved a particular row data using  "${P_result.feed.entry[1].columnName}".

ie. if a worksheet have 3 column "firstname", "lastname" and "age"

you can retrive the value by

firstname = ${P_result.feed.entry[1].firstname}

Please refer to screenshot 1 for the reference.

After retrieving,you need to create the 1 manual activity for displaying the spreadsheet data in the Web Interface. Please use the the same variable name in the web interface that are used in the process to populate those field from the spreadsheet data.

Kindly refer to the screenshot 2 and 3 for the same. 

Once any data is modified from the Web Interface, kindly use the "Update a row [v3]" connector to update the spreadsheet row.

row data structered is as followed:-

{"age":"13","id":"https://spreadsheets.google.com/feeds/list/1bC8YGTDbPrtdckJoCz657AxCCB5xXqZEqHfLh6NjQMs/1/cokwr","category":{"@term":"http://schemas.google.com/spreadsheets/2006#list","@scheme":"http://schemas.google.com/spreadsheets/2006"},"firstname":"p11","content":"lastname: p12, age: 13","updated":"2015-05-25T18:04:08.160Z","title":"p11","edited":"2015-05-25T18:04:08.160Z","@etag":"\"E0UUDE8FASt7ImA4GRM.\"","lastname":"p12","link":[{"@href":"https://spreadsheets.google.com/feeds/list/1bC8YGTDbPrtdckJoCz657AxCCB5xXqZEqHfLh6NjQMs/1/private/full/cokwr","@rel":"self","@type":"application/atom+xml"},{"@href":"https://spreadsheets.google.com/feeds/list/1bC8YGTDbPrtdckJoCz657AxCCB5xXqZEqHfLh6NjQMs/1/private/full/cokwr","@rel":"edit","@type":"application/atom+xml"}]}

Here "cokwr" is the id of the row that you need to pass in the connector.

Once user validated/change the data of the spreadsheet by this connector spreadsheet will be updated.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/18edd151-bce3-4013-81ad-1b46616c01e3%40runmyprocess.com.