Skip to main content

Notifications

Community site session details

Community site session details

Session Id : W74xYlvWQKYwVaNGcvQR4p
Power Automate - Building Flows
Unanswered

Creating a flow for Google Form responses

Like (0) ShareShare
ReportReport
Posted on 14 Jul 2021 16:31:21 by

Hi everyone,

 

Can anyone point me to a tutorial or how to create a flow that would allow me to convert Google form responses to PDF? What I'm looking to do is this process:

 

  • Google form entry is submitted
  • Line entry recorded in Google Sheet
  • New line entry detected by Flow
  • Data from the line entry is extracted and placed in a PDF that shows the data on individual lines
  • The PDF is either emailed to an address or placed in a Google Drive location.

 

Any help would be appreciated.
Thanks!
  • takolota1 Profile Picture
    4,859 Super User 2025 Season 1 on 09 Jul 2022 at 00:59:40
    Re: Creating a flow for Google Form responses

     @hoaikhong00 @abm 

     

    You can use some of the stuff provided in this video to set up an HTTP receiver to get the form data on submission.

    https://youtu.be/611sRKsEIRc

    Personally, I didn’t like the way the output was formatted in the sample code, so I edited the sample code to output a normal JSON body with the form results.

     

     

     

    function setUpTrigger(){ ScriptApp.newTrigger('sendPostRequest') .forForm('InsertFormIdHere') .onFormSubmit(); } function sendPostRequest(e){ var form = FormApp.openById('InsertFormIdHere') var responses = form.getResponses() var formDataLast=responses[responses.length - 1] var formData=formDataLast.getItemResponses() var sendData ={} sendData["email"] = formDataLast.getRespondentEmail(); //var emailUser = {"email":formDataLast.getRespondentEmail()} //sendData.push(emailUser) for(var k=0; k<formData.length;k++){ var newTemp = formData[k] var key = newTemp.getItem().getTitle().toString() var val =newTemp.getResponse() sendData[String(key)] = String(val); //var keyVal = {[key]:val} //sendData.push(keyVal); } Logger.log(JSON.stringify(sendData)) var options = { 'method' : 'post', 'contentType': 'application/json', 'payload' : JSON.stringify(sendData) }; UrlFetchApp.fetch('InsertFlowHTTP-URI-Here', options);

     

     

     

  • Mari Profile Picture
    on 16 Jul 2021 at 14:56:16
    Re: Creating a flow for Google Form responses

    Hi! I found a similar question in another thread, maybe this could help you: 

    Solved: can we use google form connector in power automate... - Power Platform Community (microsoft.com)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 73

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 66 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard
Loading started