How to manipulate cells (with data) that have been inserted in a new row after the form submission

[adrien...@arismore.fr]

Hello

My aim is to fill a pre-formated spreadsheet from a google form. The issue I am facing is The new row inserted after submitting a new form is not applying the formatting I have defined for my sheet.

I would like to manipulate the inserted cells and their data using the trigger onFormSubmit. Unfortunately I do not manage to get the new cells to match the rest of them because I do not know how to get the required elements from the triggered function (how can we get the event object as well). The user need a manual action to update the format.

Could you help me with it ?

Thanks a lot

[Umesh Dengale]

Hello,

This forum is related to the AdWords API. Please post your question in the Apps Script and follow the instructions for posting.

Thanks,

Umesh, AdWords API Team.