How to Fetch data from gdoc to gsheet using Appscript
up vote
-4
down vote
favorite
I have a google word Doc which contains a table of feed back from different customers, this data is manually entered and it is going to increase every day (every day new rows will be added).
I want to fetch the data from google doc to Google Sheet, and if new data inserted in google doc should be reflect in my gsheet.
How can i achieve this using google app script, Please find the attached screen shot data for reference
Sample word document data
Expected output using app script
i am looking the same format which is the word document have.
javascript
google-apps-script google-sheets google-docs asked Nov 11 at 17:49
kalyan4uonly
53
add a comment |
up vote
-4
down vote
favorite
I have a google word Doc which contains a table of feed back from different customers, this data is manually entered and it is going to increase every day (every day new rows will be added).
I want to fetch the data from google doc to Google Sheet, and if new data inserted in google doc should be reflect in my gsheet.
How can i achieve this using google app script, Please find the attached screen shot data for reference
Sample word document data
Expected output using app script
i am looking the same format which is the word document have.
javascript
google-apps-script google-sheets google-docs asked Nov 11 at 17:49
kalyan4uonly
53
It boils down to something like thisbody.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();
– Cooper
Nov 11 at 21:21
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38
add a comment |
up vote
-4
down vote
favorite
up vote
-4
down vote
favorite
I have a google word Doc which contains a table of feed back from different customers, this data is manually entered and it is going to increase every day (every day new rows will be added).
I want to fetch the data from google doc to Google Sheet, and if new data inserted in google doc should be reflect in my gsheet.
How can i achieve this using google app script, Please find the attached screen shot data for reference
Sample word document data
Expected output using app script
i am looking the same format which is the word document have.
javascript
google-apps-script google-sheets google-docs asked Nov 11 at 17:49
kalyan4uonly
53
I have a google word Doc which contains a table of feed back from different customers, this data is manually entered and it is going to increase every day (every day new rows will be added).
I want to fetch the data from google doc to Google Sheet, and if new data inserted in google doc should be reflect in my gsheet.
How can i achieve this using google app script, Please find the attached screen shot data for reference
Sample word document data
Expected output using app script
i am looking the same format which is the word document have.
javascript
google-apps-script google-sheets google-docs javascript
google-apps-script google-sheets google-docs asked Nov 11 at 17:49
kalyan4uonly
53
asked Nov 11 at 17:49
kalyan4uonly
53
edited Nov 12 at 18:25
asked Nov 11 at 17:49
kalyan4uonly
53
asked Nov 11 at 17:49
kalyan4uonly
53
asked Nov 11 at 17:49
kalyan4uonly
53
53
It boils down to something like thisbody.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();
– Cooper
Nov 11 at 21:21
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38
add a comment |
It boils down to something like thisbody.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();
– Cooper
Nov 11 at 21:21
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38
It boils down to something like this
body.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();– Cooper
Nov 11 at 21:21
It boils down to something like this
body.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();– Cooper
Nov 11 at 21:21
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53251506%2fhow-to-fetch-data-from-gdoc-to-gsheet-using-appscript%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It boils down to something like this
body.getChild(childindex).asTable().getRow(j).getCell(k).editAsText().getText();– Cooper
Nov 11 at 21:21
Could you provide me the complete script
– kalyan4uonly
Nov 12 at 5:11
If something is strike through then it won't be copied into sheet as well
– kalyan4uonly
Nov 12 at 17:27
How to avoid strike through words while extracting?
– kalyan4uonly
Nov 13 at 8:38