How could I input data to other worksheet in the Sheet

Question

First of all, I'd like to input data to "test" worksheet, but I don't know how to write this code.

Second, I know there's different Shareable sheet link(.../edit#gid=267921143) each worksheet. However, I use Sheet.Best to convert into a API link.

It's suitable for a main page(forhere worksheet, link:.../edit#gid=0) of the Sheet below the code, and can work. That's why I want to use it to turn into other worksheet.

Tool: Dialogflow integrate with the Sheet(SheetDB & Sheet.Best)

Could someone give me a favor? Thanks a lot~

 function saveData(agent){
    const{
      name, age, email, phone, gender
    } = agent.parameters;
    const data3 = [{
      Name:name,
      Age:age,
      Email:email,
      Phone:phone,
      Gender:gender
    }];
    axios.post('https://sheet.best/api/sheets/...API...', data3);
  }

enter image description here

I am not familiar with axios, but those links show you how to append values to a sheet with jNode according to the Google documentation: https://developers.google.com/sheets/api/guides/values https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append As for exporting sheets — ziganotschka, Sep 24 '19 at 09:44

score 0 · Answer 1 · answered Sep 25 '19 at 07:17

0

Have already done.

Link: https://sheet.best/docs/working-with-tabs

Fix: axios.post('https://sheet.best/api/sheets/...API.../tabs/tablename, data3');

answered Sep 25 '19 at 07:17

李宇澄

53
1
2
7

How could I input data to other worksheet in the Sheet

1 Answers1