在Chrome扩展中使用Google API电子表格JS移除值

<script src="https://apis.google.com/js/api.js"></script>

function authorize(callback) {
  const clientId = 'YOUR_CLIENT_ID';
  const apiKey = 'YOUR_API_KEY';
  const scopes = 'https://www.googleapis.com/auth/spreadsheets';

  gapi.client.init({
    apiKey: apiKey,
    clientId: clientId,
    scope: scopes,
    discoveryDocs: ['https://sheets.googleapis.com/$discovery/rest?version=v4']
  }).then(function() {
    gapi.auth2.getAuthInstance().signIn().then(callback);
  });
}

function removeValues(spreadsheetId, range) {
  gapi.client.sheets.spreadsheets.values.clear({
    spreadsheetId: spreadsheetId,
    range: range
  }).then(function(response) {
    console.log('Values removed successfully');
  }, function(error) {
    console.error('Error removing values:', error.result.error.message);
  });
}

document.getElementById('removeValuesButton').addEventListener('click', function() {
  authorize(function() {
    removeValues('YOUR_SPREADSHEET_ID', 'Sheet1!A1:B2');
  });
});