If I integrate my form with a google spreadsheet, is it possible for that spreadsheet to send an email with the results which are calculated by the sh

  • Profile Image
    smithkim
    Asked on April 14, 2013 at 04:34 PM
  • Profile Image
    EltonCris
    Answered on April 14, 2013 at 07:55 PM

    Hi,

    Can you please complete your question? I can't seem to understand it well. 

    Also, I am thinking what you want to achieved is not possible with gspreadsheet. If I got your question correctly, how about using grid listing or html table listing report? You can add them to your autoresponders.

    Grid Listing

    Create an HTML Table Listing Report

    We'll wait your reply about this. Thanks!

  • Profile Image
    smithkim
    Answered on April 15, 2013 at 03:46 AM
    Hi, the missing word in my question is sheet, which I think you probably guessed. It seems my question just had too many characters!From what I can make out, grid listings and table listings only show the submissions. I want to be able to send each person who makes a submission the outcome produced by the spreadsheet. I can make that outcome appear in my webpage by embedding the googlesheet there and then it gets updated automatically but I then want a way of sending that output to the user.Kim
  • Profile Image
    Welvin
    Answered on April 15, 2013 at 04:31 AM

    Hi Kim,

    Please note that modifying the Google Spreadsheet result may brake the integration. Also, the results or submissions are not separated on a different sheets, they are group in a single spreadsheet.

    You may just do this manually and send them the result using their email addresses from the form submissions list.

    Or, if you can manage "ImportRange".

     

    Thanks

  • Profile Image
    smithkim
    Answered on April 15, 2013 at 04:39 AM
    Thanks. I have used importrange recently so I know how that works. But that still doesn't tell me how to automate the result to the user?
  • Profile Image
    Welvin
    Answered on April 15, 2013 at 04:55 AM

    Hi Kim,

    You may consider publishing/sharing the Google Spreadsheet as HTML then just give them the link through your Form Auto Responder. The HTML Link is live and will capture any updates made on the sheet.

    Thanks

  • Profile Image
    smithkim
    Answered on April 15, 2013 at 05:09 AM
    That's a manual process each time though isn't it? I want this automated if possible.
  • Profile Image
    Welvin
    Answered on April 15, 2013 at 05:36 AM

    Hi Kim,

    No, all are automated. You will have to use the ImportRange Function to query all the results from the original sheet into another spreadsheet. This another spreadsheet will contain your formulas/calculations. You can then share this another spreadsheet in HTML Method as suggested on my previous response. 

    Let me know if you need more clarification or let me know if I am lost on what you are trying to achieve. You want to calculate the results, right? The mean purpose of this method base on what I have understood is how you can manage to calculate the results and share it to anybody.

    Or, if you mean to automatically calculate submission individually and also give them the result into a separate single spreadsheet, unfortunately, that is not possible with this method. All submissions are present on a single spreadsheet and formulas for each submissions are visible to everyone.

     

    Thanks

  • Profile Image
    smithkim
    Answered on April 15, 2013 at 05:46 AM
    I understand what you say. However, although the resulting calculation is shown on a webpage, the user still doesn't receive an email with the results, which is what I would ideally like.
  • Profile Image
    Welvin
    Answered on April 15, 2013 at 06:09 AM

    Hi Kim,

    An Email from the Google Spreadsheet result changes is not possible.

    You may consider giving them the link through "Form Auto Responder" as suggested above and advice them to bookmark the link and check every time.

     

    Thanks