title: Copy / Paste format using gspread
body: <p>I am trying to copy / paste format from once column to another using <code>gspread</code>. My sheet looks like this:</p>
  <p><a href="https://i.stack.imgur.com/RODAM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RODAM.png" alt="enter image description here" /></a></p>
  <p>My result should look like this:</p>
  <p><a href="https://i.stack.imgur.com/9A3rK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9A3rK.png" alt="enter image description here" /></a></p>
  <p>I tried:</p>
  <p>But for some reason this does not copy the format and I am not sure where is my mistake.</p>
  <pre><code>GSHEETS_SCOPES = [
      &quot;https://www.googleapis.com/auth/spreadsheets&quot;,
      &quot;https://www.googleapis.com/auth/drive.file&quot;,
      &quot;https://www.googleapis.com/auth/drive&quot;
  ]
  
  
  
  CLIENT_SECRET_GOOGLE_SHEETS = r&quot;folder/file.json&quot;
  creds = ServiceAccountCredentials.from_json_keyfile_name(CLIENT_SECRET_GOOGLE_SHEETS, GSHEETS_SCOPES)
  client = gspread.authorize(creds)
  sheet = client.open(&quot;My Sheet&quot;)
  
  body = {
      &quot;requests&quot;: [
          {
              &quot;copyPaste&quot;: {
                  &quot;source&quot;: {
                      &quot;sheetId&quot;: sheet.id,
                      &quot;startRowIndex&quot;: 1,
                      &quot;endRowIndex&quot;: 30,
                      &quot;startColumnIndex&quot;: 0,
                      &quot;endColumnIndex&quot;: 1
                  },
                  &quot;destination&quot;: {
                      &quot;sheetId&quot;: sheet,
                      &quot;startRowIndex&quot;: 1,
                      &quot;endRowIndex&quot;: 30,
                      &quot;startColumnIndex&quot;: 1,
                      &quot;endColumnIndex&quot;: 2
                  },
                  &quot;pasteType&quot;: &quot;PASTE_FORMAT&quot;
              }
          },
          
          }
      ]
  }
  res = sheet.batch_update(body)
  </code></pre>