This is my final project in view mode :  https://drive.google.com/open?id=1gOOb3hND3q2v0vTy8SfPVHFiCnTkJPR5  each row corresponds to a Google Doc project so when I modify in the row it will modify the corresponding Doc and when I click to see the doc...
I am pulling my hair out ! Help !! UPDATE: I am using v1.0.0 of google-auth-library and v24.0.0 of googleapis.  const { JWT } = require('google-auth-library'); var google = require('googleapis'); var sheets = google.sheets('v4'...
Trying to copy a whole spreadsheet but I guess there is no api to do so.  Basically, I am trying to do the following:   Have a spreadsheet which I would like to duplicate with minor changes. Create a new spreadsheet, copy all sheets from a template i...
I am writing a program that requires the ID of various google form responses. My program first creates the form object and gets the responses:  var form = FormApp.openByUrl("..."); var allResponses = form.getResponses();   If the form respons...
The data is coming from Google Sheets API, hence employees.stratdate, employees.enddate etc.   I need to be able to display only the employees that used to work in a selected month. If they don't work anymore, but used to work then, they should b...
Can't get the Google Sheets API v4 code working from Google Apps Script for adding named/protected ranges to the Google Sheet, used the code sample from here [[link]][1]. It gives the error (what is the correct json form for this?):      Invalid...
I am having problems writing to a Google Sheet and I can not figure out why.  I am new to using this API and have been using the Google API Client Libraries Guides, for the JavaScript client library.   I am trying to build a "Sign In" webpage...
I would like to filter a google sheet range for rows that only contain a particular value of "Bob" in Column 1. My code so far lets me filter out the rows that have Bob in Col 1. I need to opposite, I want to return the rows that only have &#...
I've never used Javascript before and i've been trying for ages to do this but with no luck, and I can't find any previous people trying. I want to copy the text data straight from this txt document in my drive, it is possible to do this...
I am using this function to pull information from coinmarketcap using their v2 api. The problem I am getting is that if a "website_slug" does not exist on coinmarketcap, I get an incorrect range width error instead of the function just puttin...

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.