Unable to open the script editor in the Google Sheet

  • Profile Image
    Asked on August 29, 2019 at 04:52 AM

    Hello! I have a problem, I don't know if it's your job but I try to ask the question.

    I integrated my module with google sheet, but the integration does not allow me to open the "script editor" tool on google sheet.

    has it already happened?

  • Profile Image
    Answered on August 29, 2019 at 05:12 AM

    Please be noted that making any changes to the integrated spreadsheet file will most likely break the integration.

    You can use Google's Import Range function so you can transfer spreadsheet data from one spreadsheet to another. There in the new sheet, you can add whatever calculations you like.

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

    Guide: https://www.tillerhq.com/understanding-importrange-in-google-sheets/

    Please let us know if you need further assistance.