title: How add lines in a text to an append request on API Google spreadsheet without destroy my quota
body: <p>I'm not an expert programmer and I extract some data to a text file, and now I want to import it to a Google spreadsheet. I can do this and it works till quota limits. How can I add all the lines to a single request?</p>
  <pre><code> insert_data_option = 'OVERWRITE'  
  
          
          with open(r&quot;juntos.txt&quot;, &quot;r&quot;, encoding=&quot;utf8&quot;) as inputfile:
              for line in inputfile:
                  string = line.rstrip(&quot; \n&quot;)
                  value_range_body = {
    &quot;majorDimension&quot;: &quot;ROWS&quot;,
    &quot;range&quot;: &quot;A:B&quot;,
    &quot;values&quot;: [
      [
        string
      ]
    ]
  }
  
                  request = service.spreadsheets().values().append(spreadsheetId=spreadsheet_id, range=range_, valueInputOption=value_input_option, insertDataOption=insert_data_option, body=value_range_body)
                  response = request.execute()
  </code></pre>