# Need Help - External Forms, User Data, and Data Work Flow ideas

**URL:** <https://community.glideapps.com/t/need-help-external-forms-user-data-and-data-work-flow-ideas/56083>\
**Category:** Ask for Help\
**Created:** [December 27, 2022, 10:53am UTC](https://community.glideapps.com/t/need-help-external-forms-user-data-and-data-work-flow-ideas/56083 "2022-12-27T10:53:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Davinci](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/davinci/32/52086_2.png) [@Davinci](https://community.glideapps.com/u/Davinci)\
**Post date:** [December 27, 2022, 10:53am UTC](https://community.glideapps.com/t/need-help-external-forms-user-data-and-data-work-flow-ideas/56083/1 "2022-12-27T10:53:24Z")

</div>

Alright i’m about a week into glide and i’m absolutely loving it but im a bit lost in terms of user data and relationships - that i may or may not be able to create.

Here’s my use case: **high level overview** for context. - can be skip  
it’s a 3 sided marketplace! (sort of)

1/3: users (client) submit data via friendly and easy wp form that data is essentially a lead (an open lead). We have 2 other parties remaining 2/3 party(s) will submit information - call it verification on the clients (open lead data), and the last party member 3/3 will be able to see majority of data except contact info. they will make offer/input and this gets displayed back to the user in their dashboard.

What i have done successfully so far.  
✅ WP website lead form with 12 columns of data including user email webhook(ed) to gsheets and displaying in my glidepages app. -successful

What im having trouble understanding

1. My gsheet data (lead) exist but how can i make it into a thing that belongs to a user. and systematically pass that data through a stage like process. I’ve tried relational, if - then, targeting user email and i seem to be missing something.

In an ideal world this is how i envision it.

user submits form (external) → data in gsheet mirrored in glide → (somehow- automatically a user is created/ invitation sent. (and maybe the gsheet data is passed to a new data set) But that lead data is stored or linked to that users email, so when they sign in - using the same email this " new thing" is carrying the gsheet data and will display to the user once signed in. The process continues through the stages i mentioned earlier.

any guidance or ideas would go a long way.

Thanks.  
Go Glide!

---

<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:** [December 27, 2022, 11:07am UTC](https://community.glideapps.com/t/need-help-external-forms-user-data-and-data-work-flow-ideas/56083/2 "2022-12-27T11:07:32Z")

</div>

> [@Davinci](#):
>
> user submits form (external) → data in gsheet mirrored in glide → (somehow- automatically a user is created/ invitation sent. (and maybe the gsheet data is passed to a new data set) But that lead data is stored or linked to that users email, so when they sign in - using the same email this " new thing" is carrying the gsheet data and will display to the user once signed in. The process continues through the stages i mentioned earlier.

All you really need is an email address in the data being ingested to your Google Sheet.  
Then build a (multiple) relation from your Users Table in Glide to that sheet, matching the respective email address columns.

Then you can present the data as an inline list/collection in your App, and the first time a user signs in, any data that matches their email address will be there waiting for them.

If security of the data is important, you might also want to look into [Row Owners.](https://www.glideapps.com/docs/reference/security-and-user-data/row-owners)