How to Transfer data from Kylas to Google Sheets?

How to Transfer data from Kylas to Google Sheets?

Step by Step Process

1. Open the google sheet with the records you want to export. Navigate to Extensions> click on Apps Script.


2. You'll attain a quick platform to enter the script with functions.



Note - User needs to get "functions" written from the developers end in order to extract the data from the required fields.

3. Post writing the script. Go to Deploy> click on New Deployment.


4. Navigate to select type > choose Web app > click on deploy.


5. It will generate the URL after deployment. Copy and paste it in your Kylas account whilst creating a new webhook.


6. Go back to your Kylas account. Navigate to Integrations > Webhook > Add a New Webhook. (Name the webhook, add the URL, select the Authentication , allow the webhook permission for the required entity as per your records , enable the status as active and save it.)


For reference here we have set the event to create a Lead therefore whenever the lead would be generated in Kylas, data will pass through the URL, we have pasted in the Webhook section and according to the parameter user has set, it will capture the data in the google sheet.

    • Related Articles

    • How to integrate Kylas CRM with your Indiamart account to capture leads?

      This article covers the steps for integrating your Indiamart account with Kylas CRM to automatically fetch leads generated in Indiamart and store them in your Kylas CRM account. Prerequisites Permissions:  Any user with access to the Kylas account ...
    • How to connect Exotel with Kylas CRM?

      This article will help you walkthrough with the steps on how to sync Exotel with Kylas CRM. Prerequisites Permissions - Any user with access to the Kylas account API key or having access to Kylas marketplace. (a) Contact - read, read all, create, ...
    • How to connect Knowlarity with Kylas CRM?

      Knowlarity Communications is a cloud telephony. This article will help you walkthrough with the steps on how to sync it with the Kylas CRM. Prerequisites Permissions - Any user with access to the Kylas account API key or Access to Kylas Marketplace. ...
    • How to connect Ozonetel with Kylas CRM?

      This article will help you walkthrough with the steps on how to sync Ozonetel with Kylas CRM. Prerequisites Permissions - Any user with access to the Kylas account API key or Access to Kylas Marketplace. (a) Contact - read, read all, write, update, ...
    • Kylas Caller Integration

      This article covers the steps to be followed and the prerequisites for installing a marketplace app. This app helps you connect your cloud telephony provider with Kylas CRM. Kylas Caller app- This helps users to connect their cloud telephony apps ...