Skip to main content

Create the Google Sheet by Deluge || Create a button By Zoho Flow | Create a button to move lead to google sheet

Create connection 


name =vksheet

new connection>search google sheet>


scope=


https://www.googleapis.com/auth/drive


https://www.googleapis.com/auth/drive.file


https://www.googleapis.com/auth/drive.readonly


https://www.googleapis.com/auth/drive.readonly


https://www.googleapis.com/auth/spreadsheets


https://www.googleapis.com/auth/spreads

 


record = zoho.crm.getRecordById("Leads",id);

// info record ;

Last_Name = record.get("Last_Name");

First_Name = record.get("First_Name");

Email = record.get("Email");

Phone=record.get("Phone");

insertData1={"properites":{"title":"mysheet"}};

insertData2={"sheets":{{"properites":{"title":"Sheet Data"}}}};

allmap=Map();

allmap.putAll(insertData1);

allmap.putAll(insertData2);

newSheet = invokeurl

[

url: "https://sheets.googleapis.com/v4/spreadsheets"

type: POST

parameters: allmap.toString()

connection: "vksheet"

];


info newSheet ;

sheetid=newSheet.get("spreadsheetId");

sheeturl=newSheet.get("spreadsheetUrl");

info sheetid ;

info sheeturl ;

sheetid = "19CsMY7b8MFxPaLS4Zrfku6fw5wgDsXW2DI1d74XLudI";

index = 2;

datamap = {"data":{{"range":"A" + index + ":A" + index,"majorDimension":"ROWS","values":{{Last_Name}}},{"range":"B" + index + ":B" + index,"majorDimension":"ROWS","values":{{Email}}},{"range":"C" + index + ":C" + index,"majorDimension":"ROWS","values":{{First_Name}}}},"valueInputOption":"ROWS"};

update_my_sheet = invokeurl

[

url :"https://sheets.googleapis.com/v4/spreadsheets/" + sheetid + "/values:batchUpdate"

type :POST

parameters:datamap.toString()

connection:"vksheet"

];

update_sheet = zoho.crm.updateRecord("Leads",id,{"Sheet_Url":"https://docs.google.com/spreadsheets/d/19CsMY7b8MFxPaLS4Zrfku6fw5wgDsXW2DI1d74XLudI/edit#gid=0"});

info update_sheet;


return "Data is Moved";

Labels:

Comments

Post a Comment

Popular posts from this blog

How to convert Url to Imege/File By Deluge for Creator || Using the Upload Api || How to upload Imege in zoho creator from crm

This code snippet appears to be part of a script or program that involves invoking URLs to handle file uploads. Let's break it down: 1 Invoke the URL to retrieve a file ( Logo ) : Logo is the url of Imege like Logo =" https://images.pexels.com/photos/674010/pexels-photo-674010.jpeg" response = invokeurl [ url :Logo type :GET ]; Here, the code is making a GET request to a URL stored in a variable named Logo . This request likely retrieves some file data. 2. Setting parameters : response.setParamName("file"); This line sets a parameter named "file" in the response obtained from the previous request. It prepares the response to be sent as a file in a subsequent request. Logo_imge = invokeurl [ url :"https://creator.zoho.com/api/v2.1/clientnamexxxxx/appnamexxxx/report/demo_report/" + CreatorID + "/Logo/upload" type :POST files:response connection:"creator" ]; 4. Logging info "Logo_imge==" + Logo_imge; This p...
Post a Comment
Read more

Creator 's Html snippet with EJS tag

  An Introduction to EJS: The Embedded JavaScript Templating Engine When it comes to creating dynamic web applications, rendering HTML pages with server-side data is an essential task. Many developers turn to templating engines to simplify this process, and one of the most popular choices is EJS (Embedded JavaScript) . If you're unfamiliar with EJS or are considering it for your next project, this blog will provide a comprehensive introduction to its benefits, features, and how to get started with it. What is EJS? EJS is a simple templating language that lets you generate HTML markup with plain JavaScript. The main goal of EJS is to make it easier to embed JavaScript code directly into your HTML templates. It allows you to add dynamic content, use logic like conditionals and loops, and even include reusable components. EJS is commonly used in Node.js applications for rendering server-side views, and it integrates seamlessly with Express.js, one of the most popular web frameworks fo...
1 comment
Read more

How to Add Multiple Portal By Deluge ||How How to add Different Portal Permission Set

Creating a portal to assign users to specific profiles using Deluge scripting in Zoho Creator can streamline your application’s user management. In this context, the code snippet provided assigns a user to the "Customer" profile based on their email and enables their portal access. Here's a breakdown and explanation: ### Code Explanation: 1. **Assign User to Profile:**    ```deluge    portal = thisapp.portal.assignUserInProfile(input.Email, "Customer");    ```    This line assigns the user, identified by their email, to the "Customer" profile. The `assignUserInProfile` function is a method in the Deluge scripting language that allows developers to specify which profile a user belongs to within the application. 2. **Enable Portal Access:**    ```deluge    input.Portal_Status = "Enabled";    ```    This line updates the `Portal_Status` field to "Enabled," indicating that the user now has access to the portal. ...
1 comment
Read more