Sheets - Remote API (disable all export except .pdf?)

Is there a way to embed a spreadsheet in a website that maintains document security, privacy, and allows anonymous access? i.e. Users are already logged into a private website, (some of these users are ZOHO members, some are not).

I've tried using the Viewer API, SHARE, Publish, etc... nothing seems to allow you to share a private document (and provide anonymous access) or embed it in an .html or .asp page while maintaining document security for simple file viewing? It seems the user must either have a ZOHO account, or you must manually create and maintain an organization, or it works, but you can't limit export etc...

• The closest I can get to this functionality is using the SHEETS - Remote API, but using that creates the following issue: (similar to using Viewer, etc...) When using the Sheets Remote API can i selectively disable the export functions.
  

For example, I would like users to be able to export a .pdf but would like to disable all other export functions when I am using the Remote API to embed a spreadsheet within a website.

• Alternatively, If you can not selectively disable export: Can you simply disable all export functions when setting the Sheets Remote API to "output=view, mode=view".

i.e. I would like to enable view only access with the ability to export as .pdf, (setting the form to VIEW works and I get a note on the top right of the spreadsheet that the document is opened in View Only mode): HOWEVER

• when view only is enabled, this does not disable the export function.
• Any ideas why the export function remains active when choosing to use view only with the Remote API?
• I can get this working by publishing to a public url, but this is not an option because of document security!
  

Note: I am calling a private document if that helps, i.e.

1. <form method="POST" action="https://sheet.zoho.com/remotedoc.im" target="foo" onsubmit="window.open('','foo','width=1024,height=768,status=0,titlebar=0,toolbar=0,directories=0,location=0,menubar=0,resizable=1,scrollbars=1')"><input type="hidden" name="url" value="mysheet.xls">
   <input type="hidden" name="apikey" value="mykey">
   <input type="hidden" name="output" value="view">
   <input type="hidden" name="mode" value="view">
   <!--<input type="hidden" name="filename" value="">-->
   <input type="hidden" name="lang" value="en">
   <input type="hidden" name="skey" value="">
   <input type="hidden" name="id" value="12345678">
   <input type="hidden" name="format" value="xls">
   <!--<input type="hidden" name="saveurl" value="">-->
   <input type="submit" name="submit" value="Open/Edit">
   </form>
   
   
   
   
   
   
   
   
   
   
   
   

We are trying limit the number of "Working" copies of the worksheet so everyone is always working on the same worksheet and changes are logged through ZOHO Docs. Creating a "viewable copy" within the project site is desirable for all users - ZOHO Docs lets us define user roles that are subsequently ignored using the Remote API  however because the export function remains enabled? (i.e. some users have View Only access, some have Collaborator Access, some do not have access to ZOHO Docs at all [thus the problem with creating and maintaining an organization using DOCS, and Publish] - but in using the Remote or Viewer API, i no longer have control over that access as anyone can export a copy?)

We are trying to create a quick view for (all) project members to open a spreadsheet directly within the html project site we have built for their project, without having to log into ZOHO Docs, so they can quickly view, or run a quick calc on a spreadsheet that is not intended as an update to the working document. We are using ZOHO Docs workspace for that functionality and it works great, but often people don't need to go to the trouble of logging into the workspace if they just want a quick view or printout of current worksheet and i just can't seem to figure out why the export function keeps working when setting to "View Only" mode?

see below

• Topic Participants

• timpohlad

• llcoollll

• Sticky Posts

• Zoho Office Integrator: Moving to the all-new Zoho Sheet

  We introduced the latest version of Zoho Sheet—Sheet 5—in early 2019. This new version consists of a new user interface, improved performance, and an array of useful features. As a part of this, we will upgrade our Remote API integrations to the new version's editor interface on February 29, 2020. Update: The remote API integrations upgrade to the new version's interface will be done on April 15, 2020. Here are some exciting enhancements the new version of Sheet offers for our API users: An AI-powered

• Businesses prefer Zoho Office Integrator over Microsoft WOPI - Here's why

  Businesses often have difficult decisions to make when building web applications that provide document management capabilities for their users. For example, what's the best solution to integrate with online office editors— Zoho Office Integrator or Microsoft

• Recent Topics

• Zoho Commerce - Poor Features Set for Blogging

  Hi Zoho Commerce team, I'm sure you will have noticed that I have been asking many questions about the Blogs feature in Commerce. I thought that it would be useful if I share my feedback in a constructive way, to highlight the areas which I feel need

• Pass shipping info to payment gateway Zoho Books to Authorize.net

  For some reason the integration from Zoho books to Authorize.net does not pass the shipping address. Authorize.net is ready to receive it, but zoho books does not send it

• Massive Zoho Books failure

  We have not received any communication or notification from Zoho, but we have detected that Zoho Books is not working for all our users. We cannot access or use Zoho Books. This is critical. We are trying to contact Zoho on the Spain telephone number,

• Does the Customer “Company Name” field appear anywhere in the Zoho Books UI outside of PDFs?

  Hi everyone, I’m trying to understand how the Company Name field is actually used in Zoho Books. There is a Company Name field on the customer record, but when viewing transactions like a Sales Order in the normal UI (non-PDF view), that field doesn’t

• Email outbox is now available in the sandbox

  Hello all! Testing emails without visibility has always been a blind spot in the sandbox. With the new Outbox, that gap is closed. You can now view and verify every email triggered from your sandbox, whether it’s through workflows, approvals, or mass

• Looking For Recruit Developer

  Hi everyone, I am looking for a Zoho Certified Developer to assist with a development project for MetalXpert. We are building a software system designed to bridge the gap between a candidate mobile app and an employer web portal using Zoho Recruit as

• sales IQ issue on website

  i integrated the zoho sales IQ code on the website but it is comming in distroted form i am sharing the screenshot below the website is bulit in wix platform

• Deprecation of the Zoho OAuth connector

  Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

• I need to know the IP address of ZOHO CRM.

  The link below is the IP address for Analytics, do you have CRM's? IP address for Analytics I would like to know the IP address of ZOHO CRM to allow communication as the API server I am developing is also run from CRM. Moderation Update: The post below

• Important Update: Google Ads & YouTube Ads API Migration

  To maintain platform performance and align with Google's newest requirements, we are updating the Google Ads and YouTube Ads integrations by migrating from API v19 to the newer v22, before the official deprecation of v19 on February 11, 2026. Reference:

• Zoho recruit's blueprint configuration is not functioning as mapped

  Current Status: Zoho Blueprint is not functioning as configured. Issue: We are moving a Candidate status in Zoho Recruit "for active file" but we encountered: "Status cannot be changed for records involved in Blueprint." This happens to various client

• Blocklist candidates in Zoho Recruit

  We’re introducing Block Candidate, which helps recruiters to permanently restrict a candidate from applying to current/future job openings. Once the candidate is blocked, they will no longer be able to participate in the recruitment process. This will

• Admin asked me for Backend Details when I wanted to verify my ZeptoMail Account

  Please provide the backend details where you will be adding the SMTP/API information of ZeptoMail Who knows what this means?

• Zoho Desk - Upsert Ticket

  Hi Desk Team, It is common to request more information from end-users. Using forms is a great way to ensure all the required information is collected. It would be great if there were an "upsert" option on the Zoho Form -> Zoho Desk integration which would

• All new Address Field in Zoho CRM: maintain structured and accurate address inputs

  The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Latest update

• Client Side Scripts for Meetings Module

  Will zoho please add client side scripting support to the meetings module? Our workflow requires most meeting details have a specific format to work with other software we have. So we rely on a custom function to auto fill certain things. We currently

• Introducing Multiple Sandbox Types and Support for Module's Data Population

  Register here for the upcoming Focus Group webinar on Multiple Sandbox | Help documentation to learn more about the new enhancements Hello everyone,  Sandbox in CRM is a testing environment for users to create and test new configurations like workflow

• Creator Offline

  We had online access setup and working on our iphones. We have just set it up on an 'Android Tablet' and it is not downloading all the images? We use it to show customers our catalogue. Any ideas. Offline components all setup on both devices

• Updated font library: New font styles and custom font options in Zoho Sheet

  Zoho Sheet's font library now supports 500+ font styles in 60+ languages! The updated font library is stacked with new font styles, and some of the previously available font styles have been replaced with equivalent options. There are two ways you can

• Enable or disable any Field Rule!

  Hello Zoho Forms Community, We are excited to announce a powerful new enhancement to Field Rules that gives you greater control and flexibility in managing your form logic! Previously, if you wanted to temporarily deactivate a field rule, you had two

• Marketing Tip #20: Increase traffic with strong meta titles and descriptions

  Meta titles and descriptions are what people see first on search results before they ever click through to your website. If your pages use generic titles or basic descriptions, you miss the chance to stand out, and search engines may not know which page

• Kanban view on Zoho CRM mobile app!

  What is Kanban? The name doesn't sound English, right? Yes, Kanban is a Japanese word which means 'Card you can see'. As per the meaning, Kanban in CRM is a type of list view in which the records will be displayed in cards and categorized under the given

• Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

  Not able to delete a QC nor able to revert or create a cycle of manufacturing for QC failed Jobs

• Dheeraj Sudan and Meenu Hinduja-How do I customize Zoho apps to suit my needs?

  Hi Everyone, I'm Meenu Hinduja and my husband Dheeraj Sudan, run a business. I’m looking to tweak a few things to fit my needs, and I’d love to hear what customizations others have done. Any tips or examples would be super helpful! Regards Dheeraj Sudan

• is there any way to change the "chat with us now" to custom message?

  is there any way to change the "chat with us now" to custom message? I want to change this text

• Deprecation Notice: OpenAI Assistants API will be shut down on August 26, 2026

  I recieved this email from openAI what does it means for us that are using the integration and what should we do? Earlier this year, we shared our plan to deprecate the Assistants API once the Responses API reached feature parity. With the launch of Conversations,

• Capture Last check-in date & days since

  I have two custom fields on my Account form, these are "Date of Last Check-In" and "Days Since Last Contact" Using a custom function how can I pull the date from the last check-in and display it in the field "Date of Last Check-In"? and then also display the number of days since last check-in in the "Days SInce Last Contact" field? I tried following a couple of examples but got myself into a bit of a muddle!

• CRM gets location smart with the all new Map View: visualize records, locate records within any radius, and more

  Hello all, We've introduced a new way to work with location data in Zoho CRM: the Map View. Instead of scrolling through endless lists, your records now appear as pins on a map. Built on top of the all-new address field and powered by Mappls (MapMyIndia),

• Enhance Appointment Buffers in Zoho Bookings

  There was previously a long-standing feature request related to enhancing the way appointment buffers work in Zoho Bookings, but it looks like the original post has been deleted. I am therefore adding a new request that Zoho Bookings adjust how appointment

• Subscriptions for service call

  So we install products and we want to offer a service contract for the customers yearly service calls to be billed monthly. So ideally at some point we want to email them a quote for their needs. WE will choice it our end based on the equipment. It would

• Delay in rendering Zoho Recruit - Careers in the ZappyWorks

  I click on the Careers link (https://zappyworks.zohorecruit.com/jobs/Careers) on the ZappyWorks website expecting to see the job openings. The site redirects me to Zoho Recruit, but after the redirect, the page just stays blank for several seconds. I'm

• How to add interviews through API

  I'm trying to add an interview without much luck. The documentation gives examples of adding just about everything except an interview. However, the issue might be the way I'm formatting it, because the documentation is unclear to me. It seems as if the xml should be passed in the url, which seems unusual. I've tried the data as both plain and character escaped, but nothing seems to work, nor do I even get an error response. https://recruit.zoho.com/recruit/private/xml/Interviews/addRecords?authtoken=***&scope=recruitapi&version=2&xmlData=<Interviews> <row

• Connection to other user

  Zoho Cliq handles sharing of Custom OAuth Connections that require individual user logins.

• How to invite friends on other social media platforms to one of my group chats in arattai?

  Hello, I have formed chat groups in arattai. I want to invite my friends on other social media platforms like WhatsApp/ FB to one of my groups. Different friends would be invited to different groups. How to share an invite link of one of my groups to

• Cliq does not sync messages after Sleep on Mac

  I'm using the mac app of Cliq. When I open my mac after it was in sleep mode, Cliq does not sync the messages that I received. I always have to reload using cmd + R, which is not what I want when using a chat application.

• Set expiration date on document and send reminder

  We have many company documents( for example business registration), work VISA documents. It will be nice if we can set a expiry date and set reminders ( for example 90 days, 60 days, 30 days etc.,) Does Zoho workdrive provide that option?

• Analytics : How to share to an external client ?

  We have a use case where a client wants a portal so that several of his users can view dashboards that we have created for them in Zoho Analytics. They are not part of our company or Zoho One account. The clients want the ability to have user specific,

• Payroll and BAS ( Australian tax report format )

  Hello , I am evaluating Zoho Books and I find the interface very intuitive and straight forward. My company is currently using Quickbooks Premier the Australian version. Before we can consider moving the service we would need to have the following addressed : 1.Payroll 2.BAS ( business activity statement ) for tax purposes 3.Some form of local backup and possible export of data to a widely accepted format. Regards Codrin Mitin

• Zoho Desk API - Send Reply to CUSTOMERPORTAL

  Hello! I'll try to send a reply to Customer Portal, But the response is 500 (INTERNAL_SERVER_ERROR in service response). {"Error":"{\"errorCode\":\"INTERNAL_SERVER_ERROR\",\"message\":\"An internal server error occurred while performing this operation.\"}"}

• Python - code studio

  Hi, I see the code studio is "coming soon". We have some files that will require some more complex transformation, is this feature far off? It appears to have been released in Zoho Analytics already

• Next Page