Status Update
Comments
ma...@google.com <ma...@google.com>
ma...@google.com <ma...@google.com> #2
Hello,
Thank you for your request. In order to proceed please answer these questions:
-
Describe briefly the task you are trying to accomplish.
-
What do you consider to be the impact in your workflow of not having this feature?
-
Are you currently employing any workaround?
Thank you and regards.
de...@ollion.com <de...@ollion.com> #3
Description of Task:
I am trying to create a contract document that needs to include our common agreement with the customer defined as tables in a spreadsheet.
How We are doing it right now. ?
We are creating a copy of data and pasting as a simple table in the contract document with the formatting.
Impact of this missing feature. ?
This feature gives us the benefit to refer to the originally agreed spreadsheet tables. Also will able to refresh the table if any change made in spreadsheet tables.
ma...@google.com <ma...@google.com> #4
Hello,
Thank you for submitting the details. I forwarded your request to the right team. Any updates will be posted here.
Regards.
ad...@gridium.com <ad...@gridium.com> #5
Spreadsheet charts and tables can be inserted programmatically into Google Slides, but this functionality isn't available for Google Docs. We would like to be able to generate data-driven documents, but we are currently hampered by the lack of API support.
In our case, we need to create templatized technical documentation for (non-software) engineering projects that draws heavily on a custom dataset. It would be tremendously time-saving if at the start of a project, we could automatically generate a new Google Doc that has embedded tables and charts tied to a new Google Sheet. The Sheet would be initially populated with numbers from our database, but engineers could update the figures and calculations to customize them for individual projects.
A somewhat similar result could be achieved by writing the output directly to tables in the Google Doc itself, but this isn't really a satisfactory workaround. The value of having the data in a separate sheet is that it can be easily edited and manipulated using the full power of a spreadsheet, with changes synced automatically to the Doc.
It seems like the chief value of having an API for Doc creation is that it allows routine documentation tasks to be automated, so that authors can be more productive. Unfortunately, if embedded data isn't included in the APIs, a lot of the potential productivity gains go away. The utility of this feature would extend to a lot of documentation types, such as sales proposals, etc.
is...@google.com <is...@google.com>
ll...@gmail.com <ll...@gmail.com> #6
this feature is also very relevant to our team.
Thanks and best regards.
qu...@gmail.com <qu...@gmail.com> #7
pls suggest if we have workaround for this as of now
sh...@gmail.com <sh...@gmail.com> #8
pe...@marlinmultimedia.com <pe...@marlinmultimedia.com> #9
te...@sonah.tech <te...@sonah.tech> #10
rp...@prominence.cc <rp...@prominence.cc> #11
ya...@gmail.com <ya...@gmail.com> #12
Agreed. It would be useful to generate reports programmatically by inserting a linked table in a Google Doc or Slide or modify the range of the table to meet the change in the data.
mi...@pepkor.co.za <mi...@pepkor.co.za> #13
jo...@nesta.org.uk <jo...@nesta.org.uk> #14
sa...@gmail.com <sa...@gmail.com> #15
[Deleted User] <[Deleted User]> #16
Our organisation uses numerous google docs with more than 50 linked objects synchronized with a google sheet. We would like to develop an App script that can change the google sheet ID.
So we also really need this feature, or at least the possibility to modify the Sheet linked in Gdoc table & chart objects.
be...@gmail.com <be...@gmail.com> #17
as...@gmail.com <as...@gmail.com> #18
Indeed, I have nice table with formating, hyperlinks in cells, ... and the body.appendTable(srcData); make loosing all of this.
jp...@google.com <jp...@google.com>
[Deleted User] <[Deleted User]> #19
bj...@novogrid.com <bj...@novogrid.com> #20
ma...@gmail.com <ma...@gmail.com> #21
da...@sysdig.com <da...@sysdig.com> #22
However, the lack of any App Script capability to "insertSheetsTable()" akin to "insertSheetsChart()" seriously limits this capability. For example, we calculate an overall ROI for a prospect in the Google Sheet and, while we can insert a Chart showing this graphically, we cannot insert the single cell containing the ROI as a link. The only solution is to include a text placeholder in the template Google Slide presentation and use presentation.replaceAllText to update it. However, this does not link the two values, which means any updates to the underlying Google Sheet need to be manually updated which is a significant issue.
Any workarounds or alternative solutions would be welcome, but the insertSheetsTable() capability would be the best solution.
Happy to provide additional detail if needed. Thanks for the support!
al...@kicksentertainment.com.au <al...@kicksentertainment.com.au> #23
ra...@e-conomix.at <ra...@e-conomix.at> #24
er...@societ.com <er...@societ.com> #25
p....@gmail.com <p....@gmail.com> #26
A potential use case for me is to select a certain text in a google docs document, and insert the selected text into a spreadsheet for further processing in the spreadsheet. So far this works fine with the available features. But in addition, I would then like to link back (in an automated way by means of an Apps script) the inserted ranges from the spreadsheet to the docs document (similar to manually paste and select to link the table). Without this feature, full automation is not possible.
Best Regards.
Description
I Wanted to programmatically paste a table from the spreadsheet to google Doc as
link to spreadsheet
What is the purpose of this new feature?
This new feature enables a very convenient way to refresh the table in the Document with new data when there are any changes in the linked table in the spreadsheet.
What existing Apps Script services would this affect?
None.
What existing data does this use?
None