How to programmatically create a Published Range link with Allow Interaction enabled?

How to programmatically create a Published Range link with Allow Interaction enabled?

I have a very complicated data entry use case for which, (unfortunately) a spreadsheet is the best solution.

I have a Named Range in a "master" workbook that needs to be Published to the external world with "Allow Interaction" enabled.

I copy the workbook, per-Deal, to an appropriate Workdrive folder.

How can I programmatically create the necessary Published Range link?

I'm willing to use an "alpha" release of the bits of the unpublished Sheets API which supports this.



 
    Zoho Marketing Automation
              • Sticky Posts

              • Conditional Formatting Enhancements

                We have been supporting conditional formatting in Zoho Sheet for more than 11 months now. We support setting rules on Numbers, Text, Data, Cells containing blanks, and errors. We also support setting specific formats based on the result of a Formula. This could be very powerful and could be used to color whole rows based on the value on a particular column. For example, you can define a formula criterion to color alternative rows of a table or to highlight rows if the date in one of the columns falls
              • One cell, multiple formats, unlimited possibilities.

                Spreadsheet formats are more than an aesthetic choice. Proper formatting helps audiences understand your spreadsheet better. Zoho Sheet now allows you to format different parts of your content in cells however you want. What can you do with the new formatting
              • Publish spreadsheets, sheets, or ranges with specific customizations

                Publishing a spreadsheet allows you to share your reports or data with a wider audience. To expand the publishing capabilities for your spreadsheet, we've revamped the publish controls in Zoho Sheet.   New look, extensive options With the new publish
              • Refine by Zia: a smart way to improve data quality

                Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,
              • Webinar: Learn how to instantly clean your spreadsheet data

                Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration.  ​ In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid of

              Zoho Pagesense Resources

                Zoho SalesIQ Resources



                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources



                          Zoho CRM Plus Resources

                            Zoho Books Resources


                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources


                                    Zoho Sprints Resources


                                      Qntrl Resources


                                        Zoho Creator Resources


                                          Zoho WorkDrive Resources




                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now