Edits history of script submission #22405 for ' Copy Worksheet (gsheets)'

• bunnative

  Ap­pro­ved version

  Edit in Windmill

  Embed

  //native
  
  type Gsheets = {
    token: string;
  };
  export async function main(
    gsheets_auth: Gsheets,
    sheet_id: string,
    spreadsheet_id_1: string,
    spreadsheet_id_2: string,
  ) {
    const token = gsheets_auth["token"];
  
    const COPY_TO_URL = `https://sheets.googleapis.com/v4/spreadsheets/${spreadsheet_id_1}/sheets/${sheet_id}:copyTo`;
  
    const req = {
      destinationSpreadsheetId: spreadsheet_id_2,
    };
  
    const response = await fetch(COPY_TO_URL, {
      method: "POST",
      body: JSON.stringify(req),
      headers: {
        Authorization: "Bearer " + token,
        "Content-Type": "application/json",
      },
    });
  
    return await response.text();
  }
  

  Submitted by hugo989 6 days ago