# Google sheets append not working **URL:** \ **Category:** Questions\ **Created:** [October 11, 2020, 7:04pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618 "2020-10-11T19:04:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Tomas\_Wooller-Bailey](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tomas_wooller-bailey/32/2093_2.png) [@Tomas\_Wooller-Bailey](https://community.n8n.io/u/Tomas_Wooller-Bailey)\ **Post date:** [October 11, 2020, 7:04pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/1 "2020-10-11T19:04:08Z")
Hi, I am new to n8n. So far I love it, however I can’t seem to get the append function to work in google sheets. The read function works fine, but writing seems to be an issue. I have looked at videos and it just isn’t working for me. The authentication I’m using is service account and not Oauth2, is that the issue? If not, any help would be appreciated. Also when I run the append node, google sheets is saying “Last edit was seconds ago” but I don’t see any update? Thanks ---
**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\ **Post date:** [October 11, 2020, 7:45pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/2 "2020-10-11T19:45:18Z")
Welcome to the community @Tomas_Wooller-Bailey! The first two things that come to my mind would be: 1. Does the data you “send” into the node have keys with the same name as the columns in the Sheet? 2. It always appends the data after the last totally empty row. So if there is somewhere a row anywhere with some data it appends the data after that one. So it maybe gets appended but you simply do not see it as it is so far down. ---
**Author:** ![Unashe\_Siwawa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/unashe_siwawa/32/23288_2.png) [@Unashe\_Siwawa](https://community.n8n.io/u/Unashe_Siwawa)\ **Post date:** [March 14, 2023, 10:55am UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/3 "2023-03-14T10:55:15Z")
Is there a way to append data to a new column not new row? ---
**Author:** ![giulioandreini](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/giulioandreini/32/20129_2.png) [@giulioandreini](https://community.n8n.io/u/giulioandreini)\ **Post date:** [March 14, 2023, 11:40am UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/4 "2023-03-14T11:40:02Z")
Hi @Unashe_Siwawa and welcome to our community 👋 The Google Sheets node is not designed to change the data structure of a Google Sheet, so currently is not possible to add a column. What is your use case? Why do you need to add a new column? I’m asking since maybe I can come up with a different strategy, and also because I’m always looking to understand the actual use case of our users Best ---
**Author:** ![Unashe\_Siwawa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/unashe_siwawa/32/23288_2.png) [@Unashe\_Siwawa](https://community.n8n.io/u/Unashe_Siwawa)\ **Post date:** [March 14, 2023, 12:06pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/5 "2023-03-14T12:06:11Z")
Hi @giulioandreini , Thank you, for the quick response, I actually find a way to do what I wanted, it was not to add a new column, but to add new information in a specific cell, that was empty before, Thank you so much!!! ---
**Author:** ![giulioandreini](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/giulioandreini/32/20129_2.png) [@giulioandreini](https://community.n8n.io/u/giulioandreini)\ **Post date:** [March 14, 2023, 1:00pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/6 "2023-03-14T13:00:41Z")
Glad to hear you solved your problem @Unashe_Siwawa ! Let us know if we can help in any other way and happy n8n’ing 🙂 Best ---
**Author:** ![Kiremit](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/kiremit/32/50045_2.png) [@Kiremit](https://community.n8n.io/u/Kiremit)\ **Post date:** [January 18, 2025, 2:15pm UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/7 "2025-01-18T14:15:05Z")
yes but this doesnt really solve the issue. To @giulioandreini : an actual use case would be a lead list with say 10 columns (email, name, etc.) and then you create new content (like a custom presentation with google slides for each lead) - problem would then be that you cant add the presentationID to the lead list as there is no column ---
**Author:** ![giulioandreini](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/giulioandreini/32/20129_2.png) [@giulioandreini](https://community.n8n.io/u/giulioandreini)\ **Post date:** [January 27, 2025, 11:21am UTC](https://community.n8n.io/t/google-sheets-append-not-working/2618/8 "2025-01-27T11:21:13Z")
hi @Kiremit, we currently don’t have specific operations to modify the schema of a Sheet. The way to add a column is to use the “Mapping Column Mode” → “Map Automatically” in the Append Row operation. In that case, if a column is missing it will be added to the Sheet. Example: 1. Create an Edit Fields before the Google Sheet node where you prepare the column fields you want to add: add a new column there (e.g. “column6” or “presentationID”) 2. Connect a Google Sheet node with “Mapping Column Mode” → “Map Automatically” 3. This will create the new column (e.g. “column6” or “presentationID”) if not there See the example here: Let me know if this helps Giulio