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 admin 468 days ago
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 admin 471 days ago
import * as wmill from "https://deno.land/x/windmill@v1.85.0/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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 adam186 600 days ago
import * as wmill from "https://deno.land/x/windmill@v1.70.1/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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 adam186 634 days ago
import * as wmill from "https://deno.land/x/windmill@v1.23.0/mod.ts";
export async function main(gsheets_auth: wmill.Resource<"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 rossmccrann 851 days ago