Google Spreadsheet Integration: Merge submissions dated last 6 months?

  • stevedellar
    Asked on October 13, 2016 at 9:15 AM

    I need to integrate the last 6 months is that possible that would be best for me?

     

    I do this in sheets by =QUERY(Submissions!A1:BL,"Select * ORDER by A DESC LIMIT 600 ",1)

    but by data will soon exceed google limits

  • Charlie
    Replied on October 13, 2016 at 9:21 AM

    Hi,

    I'm sorry, I'm not sure if I understood your concern.

    If you integrate a form to Google spreadsheet, it will automatically fetch all existing submission of your form and populate it on the new spreadsheet that was created after the integration. 

    If you could provide us more details of what you would like to do, please do share. 

    We'll wait for your response.

  • stevedellar
    Replied on October 17, 2016 at 5:30 AM

    This is because the data may exceed the google sheet limit for the number of cells used

  • jonathan
    Replied on October 17, 2016 at 8:37 AM

    According to Google docs...  

    The theoretical limit of the number of rows in a spreadssheet is 200,000 rows, provided you have one sheet and a single cell wide column. See also the limits below.
     
     
    Spreadsheets Each spreadsheet can be up to 256 columns, or up to 200,000 cells, or up to 100 sheets -- whichever limit is reached first. There's no limit on number of rows. Each spreadsheet can have up to 20,000 cells with formulas. Of this total, the following limits apply:You have a limit of 1000 spreadsheets. The spreadsheets that are shared with you do not count against 1000 limit. Up to 1,000 GoogleFinance formulas Up to 1,000 GoogleLookup formulas Up to 50 Import formulas The limit on spreadsheets open at one time is 11.

    ---

    I assume you want to download all of the existing submission data from 6 months of a single form. You can just download it as CSV file format and then use another external editor to combine all the CSV data. I as far as I know you can import the CSV file into google spreadsheet as well.

    You can import the CSV data in single column in spreadsheet and it will have a limit of 200,000 rows approx.

    Hope this help. Let us know if oyu need further assistance.