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
0 answers

insert "updated" code in a google doc

At the bottom of a document that we print off, we have an "updated on XXXX" statement. I'd like to be able to have that update automatically. Is there a way to get an insert code that will insert this type of metadata in a google doc?
staypuffinpc
  • 337
  • 2
  • 5
  • 21
1
vote
1 answer

Adding data into google sheet by embedding it in my blog

Is it possible to add data into google sheet from my wordpress page by embedding the google sheet. Thanks
Kinfe
  • 43
  • 6
1
vote
1 answer

How to replace all found ocurrences in a Google Docs for an hyperlink

We are actually wondering how can you for example find Bible verses in the document text and replace them for an URL of the verse on the web. For example if you have a "Jn 3.1" text it will be replaced for an hiperlink like this: Text= Jn 3.1 Link=…
White_King
  • 748
  • 7
  • 21
1
vote
2 answers

Google Image search within apps script

My goal is to have a Google docs spreadsheet of keywords that I can loop through, perform an image search for each keyword, and save the resulting image URL's in the same spreadsheet. There's a whole Google image search javascript API found here.…
jchmilew
  • 198
  • 2
  • 10
1
vote
0 answers

Google Docs =Filter() will randomly show "N/A" till I erase the function and paste it back in

I've been having a consistent issue where every =Filter() function on my spreadsheets will stop working, they will all just display "N/A" "No Matches Found In Filter Evaluation". I am filtering data from the same sheet, not importing it. I have to…
Douglas Gaskell
  • 9,017
  • 9
  • 71
  • 128
1
vote
1 answer

Transfer ownership of Google Doc Add-on to another account?

I have been developing an Add-on for Google Docs using the script editor inside of Google Docs. The time has come for my team to submit the application to the store. We usually submit from one main account so that all of our Google-related apps come…
Chris B
  • 733
  • 3
  • 10
1
vote
0 answers

How to get Google Sheet actions?

How can I see all the actions applied to a google sheet? for example: Cell A1 edited and its value changed form "foo" to "test" Column A has been deleted Insert row after row number 5 ... etc And I want to know if it is…
Ahmad Odeh
  • 61
  • 2
1
vote
1 answer

Copy the second value in each row to a specific column

Given the table: A B C D E x x 52 50 48 ... 67 69 71 73 75 ... 57 x 56 49 48 ... 62 x x 66 66 ... How to find the second number from the left in each line (marked here with *)? A B C D E Z x x 52 *50* 48 ... …
Die 7. Legion Smite
  • 11
  • 1
  • 3
1
vote
1 answer

parsing the result of ImportXML with XPATH in a google docs spread sheet

I have the following function in a cell of my google doc spreadsheet: =IMPORTXML(J15, "//meta[@name='description']/@content") I need to capture values from the following line from this facebook…
am1234
  • 59
  • 2
  • 6
1
vote
1 answer

make a table of data in google docs if cells in spreadsheet contain data

I am trying to write a script which creates a table in a google docs file with the results after a user has submitted a form. In the form the user can enter up to 16 invoices and 16 payments; however on my summary pdf I don't want to display a table…
Zehrazjp20
  • 51
  • 1
  • 9
1
vote
2 answers

Downloading google doc with Selenium

I am trying to download a google doc as a pdf using Selenium in Python. Unfortunately, my html knowledge is quite minimal and as a result I don't know what html I need to have it click file and then download as pdf. I realize that I can use the web…
hiqbal
  • 87
  • 2
  • 9
1
vote
0 answers

How can I show thumbnails for pages of an uploaded document (.pdf, .rtf, .doc & .docx)?

Revisiting an old site I created a while ago, for a client, I used to use PHP code similar to: echo "
James Anderson Jr.
  • 760
  • 1
  • 8
  • 26
1
vote
1 answer

Google Docs (with GApps Script) command to insert element without knowing its type?

Basically for cutting and pasting elements: These are all valid commands, { var doc = DocumentApp.getActiveDocument(); var body = doc.getBody(); var N = [some number]//the element to copy var elementVar = body.getChild(N) if…
Michael
  • 77
  • 8
1
vote
0 answers

Google Apps Script Error: "You do not have permission to call openById"

I am trying to use a Google Script that I found on GitHub. (It is Posted Below.) It is supposed to merge data from Google sheets into a Google Doc. However, when I try to run the script I get an error: "You do not have permission to call openById".…
Ike
  • 109
  • 3
  • 10
1
vote
1 answer

Sum columns if adjacent columns match if statements in Google Spreadsheets

I have to sum column A if adjacent column B is within a particular range. Here's what I mean: Sheet 1 A B 1 $2 November 2 $5 November Sheet 2 A 1 for each B1:B where the cell = November, sum adjacent A (my result should be $7) 2 Is…
Ringo Blancke
  • 2,444
  • 6
  • 30
  • 54
1 2 3
…
99
100