Data connections

To import data from a URL:

1. Click on the Data > Data Connection > Connect URLs.

To import data from other Zoho applications:

1. Click on the Data > Data Connection > Connect Zoho Apps.
2. From the Data Connection dialog box, choose the service you want to bring in data from.
   
3. Click the Authenticate button.
   
4. In the authentication window that opens, you'll be asked to Accept Zoho Flow's request to access data from the application you've chosen.
   
5. Once the authentication is complete, choose the data that you want to import using the Data Connection dialog box.
   
6. You can also fetch only the specific data from the desired service using the filter option. Click on the Filter option to filter data in the selected service by field.
   
7. Once done, click Next.
   

1. After you select data, you'll have to select a cell where the imported data will be displayed.  
   
2. You'll also have to specify whether you want to import data from the connected application Only Once and now, or Now and schedule periodically.
   
3. If you've chose to import data Now and schedule periodically, you can choose how often to repeat the task.
   

1. If there are more than 10000 records in a selected service, then only the recent 10000 records can be fetched.
   

1. Click on the Data > Data Connection > Manage Connections > Data Links
   
2. From the Data Link dialogue box, you can edit, delete, and refresh the data links.
   

To manage a connection: 

1. Click on the Data > Data Connection > Manage Connections > My Connections.
   
2. From the Manage Connections dialogue box, you can view the number of data connections, data links created under each connection, status of the connection, and also revoke, reconnect or delete a connection.
   
3. If you wish to delete a connection, click on the bin icon alongside the connection you want to delete. 
   

To revoke authentication for a service:

1. Click on Data > Data Connection > Manage Connections > My Connections
   
2. From the Manage Connections dialogue box, you can revoke authentication by clicking the Revoke option beside a connection.
   

What applications does Zoho Sheet Data Connection support?

1. Zoho CRM
   
2. Zoho Analytics
   
3. Zoho Creator
   
4. Zoho Books
   
5. Zoho Invoice
   
6. Zoho Projects
   
7. Zoho BugTracker
   
8. Zoho Expense
   
9. Zoho Inventory
   
10. Zoho Desk
    
11. Zoho Campaigns
    
12. Zoho Forms
    
13. Zoho Recruit
    
14. Zoho Sprints
    
15. Bigin
    
16. Zoho Billing
    
17. Zoho Survey
    
18. Zoho SalesIQ
    
19. Zoho Commerce
    
20. Zoho BackStage
    
    

Pricing

User-level permissions:

1. Collaborators are restricted from editing, refreshing, or deleting the connections or links the owner created.
   
2. However, collaborators associated with the spreadsheet can edit, refresh and delete the data connections and data links they create.

Only Org admins can enable/disable data connections to their users from the admin dashboard.