title: how to empty a google sheet using airflow/composer OR how to assign share permissions to google sheet after creating it
body: <p>I have an airflow job which can write into a google sheet, but I also need to either erase old values from the google sheet, or provide a new sheet at each run (and assign permissions so people can view it).</p>
  <p>option a:  The expected steps are:</p>
  <ol>
  <li>get data from BigQuery to GCS as csv (this is fine)</li>
  <li>delete old values from google sheet (this is the part I am missing)</li>
  <li>import csv to google sheet (this is fine)</li>
  </ol>
  <p>code might look like this, if I knew what to import and how to use it...
  <div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>from airflow.providers.google.suite.hooks.sheets import GSheetsHook
  
  #...othertasks
  
  erase_me= GSheetsHook.clear(
    task_id=f'erase_me',
    spreadsheet_id=f"sheet_id",
    spreadsheet_range=f"A:K",
    retries=retries_num,
    gcp_conn_id = "my_conn",
    dag=dag
    )
  
  #...moretasks
  
  othertasks&gt;&gt;erase_me&gt;&gt;moretasks</code></pre>
  </div>
  </div>
  </p>
  <p>option b:  I would prefer to do it this way, but I also got stuck on permissions:</p>
  <ol>
  <li>get data from BigQuery to GCS as csv (this is fine)</li>
  <li>deliver csv as a brand new google sheet (while I can have airflow write the google sheet as a service account, I can't figure out how to share the google sheet with me or anyone else once it is generated.)</li>
  </ol>
  <p>Any assistance is greatly appreciated.
  airflow 2.1.2, composer 1.17.0-preview.12</p>