Is it possible to assign cells in the spreadsheet widget to columns in a Google Sheet through the GS integration?

  • Profile Image
    Asked on April 01, 2017 at 11:56 PM

    I have a fairly complex table created using the spreadsheet widget and would like to be able to send data in some of the cells to row data in a Google Sheet. Currently, each submission of my form results in all of the data from the spreadsheet widget populating a single cell on the Google Sheet.

  • Profile Image
    Answered on April 02, 2017 at 08:58 AM

    Unfortunately, it's not possible to break the submission data in the google spreadsheet. Altering the data will break the integration and create a new spreadsheet. However, a workaround can be arranged to add some functions, to eventually copy and split the data into a separate sheet. 

    Please refer to this thread that might be of help for you:


    Thank you.