• I’m exporting a large database to Google Spreadsheet Live Data. The export script provided works, except the Google Spreadsheet times out sporadically, resulting in this error: “error: Service timed out: Apps Script”

    I thought if I limited the export to the past 2-3 months, for example, that might resolve the problem. But I’m not sure how to achieve this. I figured out how to generate shortcode using the submit_time function (submit_time>-8 weeks) for don’t know how to integrate it with the Google doc.

    I also noted the “optional search” in the Google Doc cell formula (Enter in the cell the formula:
    =CF7ToDBData(“siteUrl”, “formName”, “optional search”, “user”, “pwd”) but I don’t know what search term to use for the optional search property. (optional search: leave as “” by default or add a search term to filter rows).

    Can anybody help me with this?

    many thanks,
    Jennifer

  • The topic ‘CF7 export to Google Spreadsheet Live Data – filtering rows’ is closed to new replies.