Integration of Bitstamp API with Google Sheets using Google Apps Script
Integration of Bitstamp api with Google sheets using Google apps script In this Post, we Integrate google sheets to Bitstamp API through the ‘authenticated’ section of the API so I can access my account information.This Script is to Get account balances from Bitstamp. function Bitstamp() { eval(UrlFetchApp.fetch(‘https://cdnjs.cloudflare.com/ajax/libs/jsSHA/2.3.1/sha256.js’). getContentText()); var key = ”; var secret = […]
Integration of Bitfinex API with Google Sheets using Google Apps Script
In this Post, we Integrate google sheets to Bitfinex API through the ‘authenticated’ section of the API so I can access my account information. Here is the API link.This Script is to Get account wallet balances from Bitfinex. function bitfinex() { var api_key = ”; var api_secret = ”; var apiPath = “v2/auth/r/wallets”; var nonce = […]
Integration of Bittrex API with Google Sheets using Google Apps Script
In this Post, we Integrate google sheets to Bittrex API through the ‘authenticated’ section of the API so I can access my account information. This Script is to Get account balances from Bittrex. //Enable 2FA (https://bittrex.com/Manage?view=2fa) on your account. API Keys cannot be generated unless 2FA is enabled. var key = ”; var secret = […]
Buy Localbitcons Ads in Google sheets using Google Apps Script
Buy Localbitcons Ads in Google sheets using Google Apps Script function getBuyLocalbitcoinAds(){ var options = { ‘method’ : ‘get’, ‘contentType’: ‘application/json’ }; var count = 0; var url = ‘https://localbitcoins.com/buy-bitcoins-online/ves/.json?page=1’; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Buy ads’); var lastRow = sheet.getLastRow(); if(lastRow > 1){ sheet.insertRowsAfter(lastRow, 1); sheet.deleteRows(2, lastRow-1); } do{ var response = UrlFetchApp.fetch(url, options); response = […]
Sell Localbitcons Ads in Google sheets using Google Apps Script
Sell Localbitcons Ads in Google sheets using Google Apps Script function getSellLocalbitcoinAds(){ var options = { ‘method’ : ‘get’, ‘contentType’: ‘application/json’ }; var count = 0; var url = ‘https://localbitcoins.com/sell-bitcoins-online/ves/.json?page=1’; var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(‘Sell ads’); var lastRow = sheet.getLastRow(); if(lastRow > 1){ sheet.insertRowsAfter(lastRow, 1); sheet.deleteRows(2, lastRow-1); } do{ var response = UrlFetchApp.fetch(url, options); response = […]
Integration of localbitcoin API with Google Sheets using Google Apps Script
Integration of localbitcoin API with Google Sheets using Google Apps ScriptIntegration of localbitcoin API with Google Sheets using Google Apps Script In this Post, we Integrate google sheets to Bitcoin API through the ‘authenticated’ section of the API so I can access my account information. This Script is to Get account balances from Bitcoin. function […]
Create folder and file using Google Apps Script
Create folder and file using Google Apps Script In this post, I will show you Create folder and file using Google Apps Script in Google Drive. Exercises for a flat stomach – Fitness flat stomach – Gym – Fitness, Take care leg workout oral steroids online, site to buy stanozolol – arkteams Create folder and […]
Toast in Google sheets using Google Apps Script
In this post, I will show you How to create a Toast in Google sheets using Google Apps Script. What is Toast in Google Sheets Toast is a popup window in the lower right corner of the sheets with the given message. Google Apps Script To create a toast dialog, edit or replace the greeting function as […]
Create a SideBar in Google Sheets using Google Apps Script
In this post, I will tell you how to create a sidebar in Google Sheets with Google Apps Script. The sidebar is an operation panel displayed on the right side of the screen that can be used for G Suite applications.In other words, it is a kind of user interface.official documentation of sidebar The sidebar […]
Send WhatsApp Messages from Google Sheets using Google Apps Script
Send WhatsApp Messages from Google Sheets using Google Apps Script This post shows you How to Send WhatsApp Messages from Google Sheets using Google Apps Script.I am using the WhatsMate WA Gateway service to send WhatsApp messages. we will need to register with the WhatsMate WA Gateway. Send WhatsApp Messages from Google Sheets with Google Apps Script, do this: Send WhatsApp […]