title: How to link a Google Form to a Google Sheet using Python?
body: <p>Here's my setup and what I want to accomplish:</p>
  <ul>
  <li>I currently have a Google Form set up for users to submit information, which is then logged in a Google Sheet.</li>
  <li>I then, use PyDrive to save the contents of the Google Sheet as a csv.</li>
  <li>Pandas then reads that csv, and deletes data within the csv based on certain criteria.</li>
  <li>After that, I use PyDrive to re-upload the &quot;fixed&quot; csv to Google sheets, saving over the old one.</li>
  </ul>
  <p>Here's the problem:</p>
  <p>whenever I do this, it terminates the link between the Google Sheet and Google Form. Is there some way I can preserve this link or re-link the Form and the Sheet?</p>
  <p>Here is the snippet of code I have been playing with:</p>
  <pre><code>submissions_data = drive.CreateFile({'id': ext['SUBMISSIONS_ID']})
  submissions_data.GetContentFile(&quot;data.csv&quot;, mimetype = &quot;text/csv&quot;)
  df = pd.read_csv(&quot;data.csv&quot;)
  df.drop([0],inplace=True)
  df.to_csv(&quot;data.csv&quot;, index=False)
  submissions_data.SetContentFile(&quot;data.csv&quot;)`
  </code></pre>
  <p>Preferably, I would like to find a way to do this using PyDrive, but anything will work at this point. Any help is appreciated! Thank you!</p>