# Can members export a portion of their personal data to Google Sheet?

**URL:** <https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736>\
**Category:** Feature Requests\
**Created:** [April 24, 2020, 4:09am UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736 "2020-04-24T04:09:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpk/32/6111_2.png) [@mpk](https://community.glideapps.com/u/mpk)\
**Post date:** [April 24, 2020, 4:09am UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736/1 "2020-04-24T04:09:24Z")

</div>

Curious if via Zapier end users can export pieces of selected personal data to a Google Sheet. Thanks!

---

<div class="post-metadata">

**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\
**Post date:** [April 24, 2020, 11:15am UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736/2 "2020-04-24T11:15:48Z")

</div>

Hi,  
I’ve been thinking about this for a similar application.  
The solution I have considered (but not yet seen if it will work) is to create a new tab in the Google Sheet, and then use the QUERY function to add data to that Google Sheet Tab when the correct conditions are met (E.g. the user clicks on a button which changes a boolean field in the main sheet tab to true).  
You could then have a Zap that was triggered on a new row being added to this Google Sheet Tab and you have the relevant fields available in the Zap to perform a function.  
I’m not sure if a Zap can add a new row to another Google account sheet but you could at least send an email to the user with the relevant details within the email.

Let me know if you try it!

---

<div class="post-metadata">

**Author:** ![mpk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mpk/32/6111_2.png) [@mpk](https://community.glideapps.com/u/mpk)\
**Post date:** [April 24, 2020, 12:03pm UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736/3 "2020-04-24T12:03:31Z")

</div>

Good recommendation, thanks Phil!

---

<div class="post-metadata">

**Author:** ![Darren\_Alderman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_alderman/32/66660_2.png) [@Darren\_Alderman](https://community.glideapps.com/u/Darren_Alderman)\
**Post date:** [November 15, 2020, 7:19pm UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736/4 "2020-11-15T19:19:20Z")

</div>

Has anyone made any progress on this concept?

I’ve got a project where the client would like their users to be able to export data they have entered.

It would basically be filter by user id and then export the rest of the table. Could send them an email or whatever, just some way to get them the data.

---

<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 15, 2020, 10:46pm UTC](https://community.glideapps.com/t/can-members-export-a-portion-of-their-personal-data-to-google-sheet/7736/5 "2020-11-15T22:46:30Z")

</div>

If it’s not too many fields then you can do it with Zapier but it seems in this case there are usually too many fields to send over.
