Unanswered

Creating a flow for Google Form responses

(0) Share

Report

Posted on by TamB

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!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Mari on at

Like (0)

Report

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)

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report
@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);

Was this reply helpful? Yes No