# Push formatted data from Glide App to Google Sheets

**URL:** <https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811>\
**Category:** Ask for Help\
**Created:** [November 20, 2021, 1:22pm UTC](https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811 "2021-11-20T13:22:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lee\_Keng\_Leong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lee_keng_leong/32/32986_2.png) [@Lee\_Keng\_Leong](https://community.glideapps.com/u/Lee_Keng_Leong)\
**Post date:** [November 20, 2021, 1:22pm UTC](https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811/1 "2021-11-20T13:22:13Z")

</div>

Hi there,

Will I be able to perform the following function in Glide App to Google Sheets?

1. Create columns in Google Sheets “Combine”, “Name1”, and Name2"
2. “Name1” is “Bob”
3. “Name2” is “Lee”
4. Use “Hyperformula” function to concatenate “Name1” and “Name2” into “Combine” column in Glide Data Editor
5. Update Hyperformula output “Bob Lee” from Glide Data Editor into “Combine” field in Google Sheets

I was not able to perform step 5 directly. Did I miss something?

Thanks!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 20, 2021, 2:05pm UTC](https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811/2 "2021-11-20T14:05:39Z")

</div>

You don’t need hyperformula for that, you can use a [Template Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/template-column)

To write the value back to the Google Sheet, you would need to use a [Set Column Values](https://docs.glideapps.com/all/reference/actions/single-actions/data/set-columns) action that takes the result of the template column and writes it to your “Combine” column.

Question: Do you actually need this value in your Google Sheet? What will it be used for?

---

<div class="post-metadata">

**Author:** ![Lee\_Keng\_Leong](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lee_keng_leong/32/32986_2.png) [@Lee\_Keng\_Leong](https://community.glideapps.com/u/Lee_Keng_Leong)\
**Post date:** [November 21, 2021, 4:49am UTC](https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811/3 "2021-11-21T04:49:01Z")

</div>

Thanks for this! The advice works.

I need to use Glide App formulas to update Google Sheets, because I am only using Glide App to develop a prototype for myself.

The rest of the mentoring program still depends on Google Sheets data to extract out key outputs. So I don’t have a choice, but to find a way to use Glide App to update Google Sheets.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 21, 2021, 9:01am UTC](https://community.glideapps.com/t/push-formatted-data-from-glide-app-to-google-sheets/34811/4 "2021-11-21T09:01:25Z")

</div>

If you need the value to be in Google Sheets, then just do an arrayformula column. Put this in your header column.

```auto
={"Combined Name";ARRAYFORMULA(IF(A2:A<>"",B2:B&" "&C2:C,""))}

```

Assuming your Name1 and Name2 column are B and C, respectively.