{"id":9004,"date":"2025-01-31T04:14:04","date_gmt":"2025-01-31T09:14:04","guid":{"rendered":"https:\/\/incust.com\/en\/?page_id=9004"},"modified":"2025-02-27T05:55:14","modified_gmt":"2025-02-27T10:55:14","slug":"fuel-price-script","status":"publish","type":"page","link":"https:\/\/incust.com\/en\/knowledgebase\/documentation\/fuel-price-script\/","title":{"rendered":"“Fuel Price” Script"},"content":{"rendered":"
[vc_row][vc_column width=”2\/6″][vc_wp_custommenu nav_menu=”6″][\/vc_column][vc_column width=”4\/6″][mk_fancy_title size=”32″ margin_bottom=”0″ font_family=”none”]Instructions for Setting Up and Running the “Fuel Price” Script in Google Apps Script<\/b>[\/mk_fancy_title][vc_column_text css=”.vc_custom_1738312744999{margin-bottom: 0px !important;}”]\n

\u00a0Creating a Project<\/b><\/h4>\n
    \n
  1. Please go to<\/span> Google Apps Script<\/span><\/a>.<\/span><\/li>\n
  2. Go to “New project” <\/b>to create a new project.<\/li>\n<\/ol>\n[\/vc_column_text][vc_single_image image=”9005″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738312868540{margin-bottom: 0px !important;}”]\n

    3. You can rename the project by clicking on <\/span>“Untitled project”<\/b>.<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9008″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738313062311{margin-bottom: 0px !important;}”]\n

    Configuring the Project<\/b><\/h4>\n

    Open the code editor and delete the contents of <\/span>Code.gs<\/b>.<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9009″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738313165690{margin-bottom: 0px !important;}”]\n

    Download to your computer and insert the main script code from the link:<\/span>
    \n<\/span>    https:\/\/drive.google.com\/file\/d\/1K8r2n7KU1lfAGW7206pO6ffrfObP9eM-\/view?usp=drive_link<\/span><\/a><\/h4>\n[\/vc_column_text][vc_column_text css=”.vc_custom_1738313237100{margin-bottom: 0px !important;}”]\n

    Connecting the Drive API<\/b><\/h4>\n
      \n
    1. Navigate to the <\/span>“Services”<\/b> menu on the sidebar.<\/span><\/li>\n<\/ol>\n[\/vc_column_text][vc_single_image image=”9010″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738313269136{margin-bottom: 0px !important;}”]2. Click the <\/span>“+”<\/b> icon next to <\/span>“Services”<\/b>.<\/span><\/p>\n

      3. Find <\/span>Drive API<\/b> in the list, select it, and click <\/span>“Add”<\/b>.<\/span>[\/vc_column_text][vc_single_image image=”9011″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738313355787{margin-bottom: 0px !important;}”]\n

      4. Setting up the main parameters of the script<\/b><\/h4>\n
        \n
      1. In the script, locate and configure the following parameters:<\/span>
        \n<\/span><\/li>\n<\/ol>\n[\/vc_column_text][vc_single_image image=”9012″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314283233{margin-bottom: 0px !important;}”]\n
          \n
        1. \n
            \n
          • UPDATE_CONFIG<\/b>:<\/span>
            \n<\/span>name<\/span>: Location.<\/span><\/p>\n
              \n
            • terminalApiKey<\/span>: Your terminal’s API key from Prime Dash Board.<\/span><\/li>\n
            • prices<\/span>:<\/span>\n
                \n
              • inputName<\/span>: Item name in the Excel (e.g., fuel type).<\/span><\/li>\n
              • code<\/span>: Article (system code in the Prime-fuel).<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                \u00a0<\/span><\/span><\/p>\n

                  \n
                • NOTIFICATION_RECIPIENTS<\/b>: List of email addresses for notifications.<\/span>
                  \n<\/span>We send a notification about the script execution to one or more of your emails.<\/span><\/li>\n<\/ul>\n

                  You can add our address if you want us to receive these messages as well: logs@incust.com<\/span><\/p>\n

                    \n
                  • API_URL<\/b>: API server URL. Please use for Prime-fuel: <\/span>https:\/\/api.prime-fuel.com\/v1\/term<\/b><\/li>\n
                  • SENDERS<\/b>: List of email addresses allowed to send files.<\/span>
                    \n<\/span>IMPORTANT!<\/b> You must list the email addresses from which files are processed.<\/span><\/li>\n<\/ul>\n

                    This is done for security reasons to prevent an unauthorized person from sending you a file that could change your prices.<\/span><\/p>\n

                      \n
                    • LOG_FILE_NAME<\/b>: Log file name. Please left as it is.<\/span><\/li>\n
                    • OFFSET<\/b>: PThe time when the price should take effect:<\/span>\n
                        \n
                      • inFiveMinutes<\/span>, <\/span>tomorrow<\/span>, <\/span>dayAfterTomorrow<\/span>, <\/span>inTwoDays<\/span>.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n[\/vc_column_text][vc_column_text css=”.vc_custom_1738314328755{margin-bottom: 0px !important;}”]\n

                        Setting Up Triggers<\/b><\/h4>\n

                        Open the <\/span>“Triggers”<\/b> section on the sidebar.<\/span>[\/vc_column_text][vc_single_image image=”9013″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314396335{margin-bottom: 0px !important;}”]\n

                        2. Click <\/span>“Add Trigger”<\/b>.and configure the settings:<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9014″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314467832{margin-bottom: 0px !important;}”]\n
                          \n
                        • Function to run<\/b>: Select <\/span>run<\/span>.<\/span><\/li>\n
                        • Event source<\/b>: Select <\/span>Time-driven<\/span>.<\/span><\/li>\n
                        • Type of time-based trigger<\/b>: e.g., <\/span>“Hourly”<\/b>.<\/span><\/li>\n
                        • Interval<\/b>: et an interval (e.g., every 30 minutes or every hour).<\/span><\/li>\n<\/ul>\n

                          3. Click <\/span>“Save”<\/b>.<\/span><\/h4>\n[\/vc_column_text][vc_column_text css=”.vc_custom_1738314500592{margin-bottom: 0px !important;}”]\n

                          Granting Access Permissions<\/b><\/h4>\n
                            \n
                          1. On the first run, a window will appear saying <\/span>“Authorization required”<\/b>. Click <\/span>“Review permissions”<\/b><\/li>\n<\/ol>\n[\/vc_column_text][vc_single_image image=”9015″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314562901{margin-bottom: 0px !important;}”]\n

                            2. Select your <\/span>Google account<\/b>.<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9016″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314612752{margin-bottom: 0px !important;}”]\n

                            3. If you see the warning <\/span>“Google hasn\u2019t verified this app”<\/b>, click:<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9017″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314680613{margin-bottom: 0px !important;}”]\n
                              \n
                            • “Advanced”<\/b>.<\/span><\/li>\n
                            • “Go to [project name] (unsafe)”<\/b>.<\/li>\n<\/ul>\n[\/vc_column_text][vc_column_text css=”.vc_custom_1738314705181{margin-bottom: 0px !important;}”]4. Click <\/span>“Allow”<\/b> to grant access.<\/span>[\/vc_column_text][vc_single_image image=”9018″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738314769685{margin-bottom: 0px !important;}”]\n

                              \u00a0Recommendations for Use<\/b><\/h4>\n
                                \n
                              • Set a trigger to run the script <\/span>every 30 minutes or hour<\/b> to prevent inbox clutter.<\/span><\/li>\n
                              • New prices are applied according to <\/span>OFFSET<\/strong> settings, e.g., at <\/span>00:01<\/b> the next day in the respective timezone.<\/span><\/li>\n<\/ul>\n[\/vc_column_text][vc_column_text css=”.vc_custom_1738314791740{margin-bottom: 0px !important;}”]\n

                                \u00a0Checking Price Changes<\/b><\/h4>\n

                                Scheduled price changes can only be viewed in the <\/span>management interface<\/b>. Until activation, the <\/span>old price<\/b> will be displayed.<\/span><\/h4>\n[\/vc_column_text][vc_single_image image=”9020″ img_size=”full” alignment=”center” css=””][vc_single_image image=”9019″ img_size=”full” alignment=”center” css=””][\/vc_column][\/vc_row]\n<\/div>","protected":false},"excerpt":{"rendered":"

                                [vc_row][vc_column width=”2\/6″][vc_wp_custommenu nav_menu=”6″][\/vc_column][vc_column width=”4\/6″][mk_fancy_title size=”32″ margin_bottom=”0″ font_family=”none”]Instructions for Setting Up and Running the “Fuel Price” Script in Google Apps Script[\/mk_fancy_title][vc_column_text css=”.vc_custom_1738312744999{margin-bottom: 0px !important;}”] \u00a0Creating a Project Please go to Google Apps Script. Go to “New project” to create a new project. [\/vc_column_text][vc_single_image image=”9005″ img_size=”full” alignment=”center” css=””][vc_column_text css=”.vc_custom_1738312868540{margin-bottom: 0px !important;}”] 3. You can rename the project […]<\/p>\n","protected":false},"author":24,"featured_media":0,"parent":1054,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/pages\/9004"}],"collection":[{"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/users\/24"}],"replies":[{"embeddable":true,"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/comments?post=9004"}],"version-history":[{"count":5,"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/pages\/9004\/revisions"}],"predecessor-version":[{"id":9030,"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/pages\/9004\/revisions\/9030"}],"up":[{"embeddable":true,"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/pages\/1054"}],"wp:attachment":[{"href":"https:\/\/incust.com\/en\/wp-json\/wp\/v2\/media?parent=9004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}