Google Form Data into RE

Sarah Krenicki

Currently we have a google form which adds our new independent living residents into a google sheet. The development team then goes into this sheet and manually adds the new resident to RENXT.

I am a novice user of Power Automate, but I feel as though there are steps that can be automated, either by importing the form responses directly into RENXT, or importing the new row in the sheet to RENXT. However I can't find a flow trigger along the lines of "when a google form response is submitted" or "when a row is added to a google sheet." I COULD perhaps base the flow off of the notification email I receive when a new response comes through the form… but before I embark on the most elaborate flow of my short Power Automate career, am I going down the right path here? Is this even possible?

Dan Snyder

@Sarah Krenicki It is definitely possible, but you have identified a limitation with Google Forms triggers, basically there are none.

What I would suggest is that you build your flow on a schedule (ex. 4am everyday) to get the new rows in the response sheet to create the record in RENXT.

Sarah Krenicki

Thank you Dan!

Alex Wong

there is no trigger for when google sheet is updated, however, you can look a level up.

assuming your org uses google email, there are trigger for when a new email arrive for gmail. you can use that as trigger.