Generation

generate functionSat, 07 Jan 2023

Reflect number of <p class="regist"> of https://vtuber-post.com/UCmZA7XRRzmxhM4jPltZX1Zg in column C2 of https://docs.google.com/spreadsheets/d/1dNHXFcyVyaZm6yQ4YtB1KMQ-1XeIIJDO0nzvDymCenw/edit#gid=1994597147

function reflectNumberOfPost(userId, sheetId){ var url = 'https://vtuber-post.com/api/' + userId + '/' + sheetId + '/post' var response = UrlFetchApp.fetch(url) var json = JSON.parse(response.getContentText()) var numberOfPost = json['posts'].length return numberOfPost } reflectNumberOfPost('UCmZA7XRRzmxhM4jPltZX1Zg', '1dNHXFcyVyaZm6yQ4YtB1KMQ-1XeIIJDO0nzvDymCenw')

Javascript
Generate More

Questions about programming?Chat with your personal AI assistant