What if I have several forms, but I want them ALL to funnel into the same Google Spreadsheet? How do I do that?

  • Profile Image
    luxuryhomemagazinedc
    Asked on April 09, 2014 at 05:48 PM
  • Profile Image
    EltonCris
    Answered on April 09, 2014 at 06:32 PM

    Hi,

    That's not possible with the integration as of the moment.

    The workaround is to import submissions from different google spreadsheets into a single spreadsheet using importRange function.

    Here's how:

    https://support.google.com/drive/answer/3093340?hl=en

    Example:

    Formula

    IMPORTRANGE("0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE", "Submissions!A1:C10")

    0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE - is the spreadsheet key taken from the source spreadsheet URL after key=, example:

    https://docs.google.com/spreadsheet/ccc?key=0AgxqsUM6gnFjdDQ2OGV2U0ZUbTI3S3FfUEdfVWpnaFE&usp=drive_web

    Video:

    Hope this helps!