Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onOpen(e){
- SpreadsheetApp.getUi().createMenu('INC')
- .addItem('Refesh', 'INC')
- .addToUi();
- }
- function INC(){
- console.time('Timer');
- const ss = SpreadsheetApp.getActiveSpreadsheet();
- const sheet = ss.getSheetByName('Data');
- const url = 'https://api.inc.com/rest/i5list/2021'
- const res = UrlFetchApp.fetch(url);
- const data = JSON.parse(res.getContentText());
- const output = [];
- data.companies.map((comp, index) => {
- const object = {
- Rank: comp.rank,
- Company: comp.company,
- Industy: comp.industry,
- Founded: comp.founded,
- Website: comp.website,
- 'Years on list': comp.yrs_on_list,
- Growth: comp.growth,
- Revenue: comp.raw_revenue,
- 'Previous workers': comp.previous_workers,
- Workers: comp.workers,
- Metro: comp.metrocode,
- State: comp.state_l,
- Zipcode: comp.zipcode,
- };
- if (index == 0){
- output.push(Object.keys(object));
- }
- output.push(Object.values(object));
- })
- sheet.getDataRange().clearContent();
- sheet.getRange(1,1,output.length, output[0].length).setValues(output);
- console.timeEnd('Timer');
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement