title: How to print dictionary into two columns Google Sheets
body: <p>I am trying workarounds for a discord command that modifies a document.</p>
  <p>I am have a simple question: is it possible to update a whole column with something like <code>sheet.update('B:B', scores)</code> with a dictionary (multiple objects)? I want to have columns B and C updated with the keys being in B and values in C.</p>
  <p>Before I had to use code specified in <a href="https://stackoverflow.com/q/63334270/11805086">this post</a>, and make two lists (one with the names <code>[B]</code> and one with the values <code>[C]</code>) with the names and values in their own lists, so they were nested.</p>
  <pre class="lang-py prettyprint-override"><code>for count in range(len(data['guild']['members'])): # For every guild member:
      res = requests.get(&quot;https://playerdb.co/api/player/minecraft/&quot; + data['guild']['members'][count]['uuid']) # Response from server
  
      if res.status_code != 200: # If it wasn't a success, continue the loop and print a message
          ctx.author.send(&quot;Error 1: Invaild name from player database API!&quot;)
          continue
  
      name = res.json()['data']['player']['username'] # We know it was successful if we got to this point, so it's safe to try and get data from our response
      names.append(name)
  
  # Members' GXP
      xp = data['guild']['members'][count]['expHistory']
      xp = sum(xp.values())
      xpHist.append(xp)
  
  # Weekly Total
  wTotal = sum(xpHist)
  print(xpHist)
  </code></pre>
  <p>That didn't work in the command and I am trying a dictionary method with the enumerate function.</p>
  <p>Thanks!</p>
  <p><strong>EDIT:</strong> Updated to reference code as got striked for that :)</p>