- \n
- Process Video<\/a><\/li>\n\n\n\n
- Step by Step Guide<\/a><\/li>\n\n\n\n
- FAQs<\/a><\/li>\n<\/ul>\n\n\n\n
Process Video<\/h2>\n\n\n\n
Step-by-Step Guide<\/h2>\n\n\n\n
Step 1:<\/strong> Start by creating a new Google Sheet or using an existing one.<\/p>\n\n\n\n
Ensure that your sheet has clearly defined column headers, as these will be used as keys in the API payload.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-182-1024x488.png\")
<\/figure>\n\n\n\nStep 2: <\/strong>Go to your Google Sheet and click on Extensions<\/strong> in the top menu and select Apps Script<\/strong>.<\/p>\n\n\n\n
Flow\u00a0 – <\/strong>Google spreadsheet >> Extension >> App Script<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-183.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-184.png\")
<\/figure>\n\n\n\nA new Apps Script editor window will open where you can add your automation logic.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-185-1024x576.png\")
<\/figure>\n\n\n\nStep 3: <\/strong>Delete any existing code in the editor and paste the provided script.<\/p>\n\n\n\n
function onEdit(e) {\n\n\n var sheet = e.source.getActiveSheet();\n var row = e.range.getRow();\n\n\n if (row == 1) return; \/\/ skip header\n\n\n var lastColumn = sheet.getLastColumn();\n\n\n var headers = sheet.getRange(1,1,1,lastColumn).getValues()[0];\n var rowData = sheet.getRange(row,1,1,lastColumn).getValues()[0];\n\n\n var json = {};\n\n\n for (var i = 0; i < headers.length; i++) {\n json[headers[i]] = rowData[i];\n }\n\n\n var options = {\n method: \"post\",\n contentType: \"application\/json\",\n payload: JSON.stringify(json)\n };\n\n\n var url = \"http:\/\/oneapi.msgclub.net\/OneApi\/rest\/services\/oneapi?AUTH_KEY=f3eda4a3c71b8f9295449746dcd3e95&apiid=\u201dYour API ID\u201d<\/mark>\";\n\n\n UrlFetchApp.fetch(url, options);\n\n\n}<\/code><\/pre>\n\n\n\nThis script will:<\/p>\n\n\n\n
- \n
- Capture the edited row<\/li>\n\n\n\n
- Convert the data into JSON format<\/li>\n\n\n\n
- Send it to your API endpoint<\/li>\n<\/ul>\n\n\n\n
Step 4: <\/strong>Locate the following line in the script:<\/p>\n\n\n\n
var url = <\/strong>“YOUR_API_ENDPOINT”<\/p>\n\n\n\n
Replace it with your actual API URL, including your AUTH_KEY<\/strong> and API ID<\/strong>.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-186.png\")
<\/figure>\n\n\n\nThis is the endpoint where your sheet data will be sent as the script captures the edited row data, converts it into JSON format<\/p>\n\n\n\n
Step 5: <\/strong>Click on Save (floppy icon) in the Apps Script editor and add the name of the project.<\/p>\n\n\n\n
This ensures your script is stored and ready to run.<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-187.png\")
<\/figure>\n\n\n\nStep 6: <\/strong>To automate the process, you need to set up a trigger. Click on the Triggers (clock icon)<\/strong> in the left panel.<\/p>\n\n\n\n
Flow – <\/strong>Go to trigger >> Add trigger button >> SaveFlow – <\/strong>Go to trigger >> Add trigger button >> Save<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-188.png\")
<\/figure>\n\n\n\nClick on Add Trigger<\/strong><\/p>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-189.png\")
<\/figure>\n\n\n\nConfigure the settings as follows:<\/p>\n\n\n\n
- Step by Step Guide<\/a><\/li>\n\n\n\n
![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-190.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-191.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-192.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-193.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.msgclub.net\/learn\/wp-content\/uploads\/2026\/04\/image-194.png\")
<\/figure>\n\n\n\n