Stack Overflow
Stack Overflow

Questions tagged [google-docs]

Questions related to interacting with Google word processing Documents programmatically. Usage questions about the web application should be posted at Web Applications Stack Exchange.

Google Docs is a cloud-based application and service for creating and collaborating on word processing documents. The service supports an internal API for Google Apps Script as well as an External API.

Usage questions about the web application should be posted at Web Applications Stack Exchange or the Google Drive Help Center instead of here.

Note: Google has historically used the brand "Google Docs" to encompass a suite of products, but since conforming to that would introduce ambiguity here, the tag is specifically for word processing documents while refers to the suite.

3539 questions
1
vote
1 answer

Get Table Cell Values Google Docs

We have a Google Document with a Table init, where we need to get the values inside the table cells into an Array. The table looks like this in Google Doc: I found a way to logg the values in the cells with this code: var searchElement =…
John Smith
  • 387
  • 2
  • 8
  • 24
1
vote
0 answers

Merge data in google doc template

I'm trying to merge data into a Google Docs file with python and the Google Drive API. I've added this type of syntax to my doc file: {name} and fill this with data like this (python code running on Google App Engine): self.content =…
Menno Blok
  • 21
  • 1
  • 5
1
vote
1 answer

Import data from a non public CSV into Google Sheets

I have a list of customer names i would like to import into my spreadsheet from a CSV file. Preferably every hour. The IMPORTDATA function works fantastic for this kind of operation. The problem is that i don't want to store a CSV file with…
Mathias
  • 11
  • 1
1
vote
1 answer

Disable Download/Print/Share links in google doc viewer

I am trying to find a solution for disabling Download/Print/Share links thru google API. Does anyone know how to do it? Regards
Soft
  • 1,796
  • 5
  • 19
  • 30
1
vote
1 answer

XPath evaluating to true or false instead of selected element

I am attempting to pull pricing from this website into Google Docs using ImportXML. The code for the element is
$644.96
My formula is…
JJ Martin
  • 11
  • 1
1
vote
1 answer

Trying to add THREE sets of THREE IF statements. Maybe there's a better way to do it?

I have three products, and each of them has 2 price sets: Retail and Web. I'm trying to make it easy on the client so that they can just choose "web/retail/deposit" from a dropdown and then "8oz/gallon/25lb bulk" from a dropdown and have the prices…
Cosmic Hawk
  • 225
  • 2
  • 9
1
vote
2 answers

RGoogleDocs (or RCurl) giving SSL certificate problem

I was using one of my favorite R packages today to read data from a google spreadsheet. It would not work. This problem is occurring on all my machines (I use windows) and it appears to be a new problem. I am using Version: 0.4-1 of…
Farrel
  • 10,244
  • 19
  • 61
  • 99
1
vote
0 answers

Toggle key & value pair in Google Document using Google apps script

I have one Google Document with 20 pages. I would like to insert some words with special reference as !#company_name#! into Google document with few different pages. Use Below code: var cursor = DocumentApp.getActiveDocument().getCursor(); var…
Lanover Solutions
  • 50
  • 9
1
vote
1 answer

How to change InlineImages in Google Docs to PositionedImage?

The new PositionedImage class in Google Apps Script brings up a lot of questions. How does it work in relation to the current In line/Wrap text/Break text options for images? I assume its not an InlineImage, so does it wrap text? Does the image…
John Targaryen
  • 1,109
  • 1
  • 13
  • 29
1
vote
0 answers

More efficient method of adding images to Docs?

I am using this code (from an answer to a StackOverflow question): function insertImage(barcodesObject) { // Create a document. var doc = DocumentApp.openById("DOCUMENT ID HERE"); Logger.log(JSON.stringify(barcodesObject)) for(var key in…
123
  • 595
  • 6
  • 18
1
vote
1 answer

How to count the number of items and have this sustainable when I add new items?

I am trying to create a Google Spreadsheet which is able to count the number of items, and also be sustainable when I add new items which won't affect the previous result. The table at the left is the data, and on the right is the result I am…
Martin Li
  • 73
  • 1
  • 4
1
vote
1 answer

How do you send a webhook request via a google docs add-on?

I'd like to create a google-docs add-on that sends an ajax call to a webhook. I've tried the below, but I get the following error Error ReferenceError: "$" is not defined. (line 5, file "") Code function myFunction() { var arr = 'data' …
Chris
  • 5,444
  • 16
  • 63
  • 119
1
vote
1 answer

How to sum cells in a column when respective cell in row matches VLOOKUP

Having the following sheet “Animals”, how do I get an inventory of number of Birds and Mammals?: | | A | B | | - | ------- | --- | | 1 | Animal | Qty | | 2 | Chicken | 5 | | 3 | Duck | 2 | | 4 | Pig | 7 | | 5 |…
elmimmo
  • 442
  • 2
  • 11
1
vote
0 answers

Automatically generating reference number

I am trying to develop a formula automatically to generate a unique reference number for each respondent on Google Forms. I want these numbers to increase consecutively and start with 3790. Can anyone help with this? This is a formula I…
SJ workerbee
  • 11
  • 2
1
vote
1 answer

Google Docs API list of documents and two folders with same name

I use PHP to get a list of folders, and then documents from Google Docs (two API requests). Getting a list of the folders, I can get their folderID, which is fine. However, when getting a list of documents, it returns categories, and these only…
giggsey
  • 933
  • 2
  • 11
  • 31
1 2 3
…
99 100