Issue I have a Google Sheet with data from companies financial statements in them. I have both quarterly and annual data for them, and so I have a drop down cell at the top of my sheet with a selection
Continue readingTag: google-apps-script
[SOLVED] Blob conversion: Get file as xlsx
Issue I am trying to send an email that has a xlsx file attached but the problem I’m running into is that the file is opened as PDF when I download it This is my code: function sendMail() { var
Continue reading[SOLVED] XML TypeError: Cannot read property 'getValue' of null
Issue I am new to scripting and trying to get XML content and attributes What I have is an api that gives json and converted it into XML: { "teams": [ { "id": "3692463", "name": "ABC", "color": "#f42c2c", "avatar": null,
Continue reading[SOLVED] Batch Request to Asana API in JavaScript
Issue I for some reason can’t get the formatting to work when I submit a Batch API request to the Asana API. Below are 2 sections, the first of which is how I normally would send a single request to
Continue reading[SOLVED] Choosing most liked post from facebook group
Issue Well, here is the json file http://herbalista.hol.es/group.json i am working with JSON.parse(); on Google apps script. I temporarily solve with this code by Choosing the post which have more than 15 likes, but i want to choose the one
Continue reading[SOLVED] Loop in Google App Script, loop stops, loop not complete all
Issue First, I have to apologize for my poor English skill I am using Google Apps Script I have a Google Sheet where column A has 50 link Url (50 rows) my below script works absolutely fine when it run
Continue reading[SOLVED] What's the fastest way to create an Array from another Array in App Scripts?
Issue I’m using the TextFinder class in Google App Scripts to find cells that have a particular number in them. I believe that leaves me with a RangeList object, which seems to be a kind of Javascript Array, although I’m
Continue reading[SOLVED] Error when using Google Ads API REST interface to change campaign budget through Google Apps Script
Issue I’m simply trying to construct a test script that can change/mutate a specific campaign budget using the REST interface of the Google Ads API on Google Apps Scripts but I keep on running into the following error: Exception: Request
Continue reading[SOLVED] Generate non-expiring token for Facebook Graph API to publish on Instagram Business Account via Google Apps Script
Issue To post photos on instagram using Google Apps Script, I follow these steps! To generate a short-lived token I access the Graph API Explorer, add these scopes: pages_show_list instagram_basic instagram_manage_comments instagram_manage_insights instagram_content_publish pages_read_engagement pages_manage_posts public_profile I click on generate
Continue reading[SOLVED] Exception: The parameters (String) don't match the method signature for SpreadsheetApp.Range.setDataValidation
Issue I am making a very simple Code for Google App Script and when executing it I am getting the error mentioned in the title. I use Google Sheets interchangeably in Spanish and English Language. I am wondering if this
Continue reading