How to Query Nested JSON in Google Big Query

Question

I'm currently having trouble extracting data from a JSON String.

The way the data has been pulled, everything has been nested into a single string under the data field name.

How it looks like in Big Query:

Screenshot of the Schema:

Below is an example of what the string looks like:

{"id":1381,"email":"J.Smith@gmail.com","name":"Jake Smith","sub_network_ids":[2375,2270],"extended_updated_at":"2022-01-27T00:02:14Z"}

If I simply wanted to pull the ID, Email, and Name from this string and into a table, I'm wondering how would one go about doing such? Currently, I was trying to use JSON_EXTRACT with Unnest, but that didn't pan out in the direction I thought it would.

Any help would be appreciated, thanks.