# Column assignments in Google sheets integration

**URL:** <https://community.feathery.io/t/column-assignments-in-google-sheets-integration/171>\
**Category:** Support\
**Created:** [October 12, 2023, 10:50pm UTC](https://community.feathery.io/t/column-assignments-in-google-sheets-integration/171 "2023-10-12T22:50:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![piyush](https://avatars.discourse-cdn.com/v4/letter/p/ecb155/32.png) [@piyush](https://community.feathery.io/u/piyush)\
**Post date:** [October 12, 2023, 10:50pm UTC](https://community.feathery.io/t/column-assignments-in-google-sheets-integration/171/1 "2023-10-12T22:50:57Z")

</div>

We have integrated a form with Google sheets. However, when a completely blank sheet is first populated, the column assignment to Feathery fields leaves large gaps (empty columns). For instance - for the “9 Web TT Invite to Job” form, columns A, B, C and D are filled with data from form fields. Columns E-J are blank - both coulmn header and also cell value. Columns K-M and O-Q are filled. Then the next field to be filled appeas in cloumn GO. No column header or cell value is assigned between columns R and GN.

This makes the sheet very unwieldy, almost impossible, to read as you need to keep scrolling to the right until you stumble upon the next field value.

---

<div class="post-metadata">

**Author:** ![peter](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.feathery.io/peter/32/7_2.png) [@peter](https://community.feathery.io/u/peter)\
**Post date:** [October 13, 2023, 5:58am UTC](https://community.feathery.io/t/column-assignments-in-google-sheets-integration/171/2 "2023-10-13T05:58:09Z")

</div>

cc: @AK-Rollout to help out here

---

<div class="post-metadata">

**Author:** ![AK-Rollout](https://avatars.discourse-cdn.com/v4/letter/a/46a35a/32.png) [@AK-Rollout](https://community.feathery.io/u/AK-Rollout)\
**Post date:** [October 13, 2023, 4:07pm UTC](https://community.feathery.io/t/column-assignments-in-google-sheets-integration/171/3 "2023-10-13T16:07:45Z")

</div>

Can you share the trigger (e.g. Form Completed or something else) and the Google Sheets action you are using?
