 Hi, my name is Beljika and I'm an actress based out of California and today I wanted to talk to you guys about this spreadsheet that I'm creating for talent agencies in the LA area. So I do have another spreadsheet about auditions and tracking auditions. If you guys want to check that video out, it's right here. But I wanted to show you how I am making this spreadsheet and all of the notes and stuff I'm making in case you are also seeking representation in your area. You know, this might be useful for you. It might be a good way to gather all of your information because I was simply copying and pasting a bunch of information from different places. Specifically, I am DB Pro. That's where I'm doing a lot of my research. But it was getting a little messy and then I thought, why don't I just make a spreadsheet and then I can also share with you guys how I'm making these spreadsheets for this one in particular, I am currently doing research for agents and casting directors in the LA area. But this spreadsheet is going to be specifically for LA agents, LA talent agencies. So I am seeking commercial and theatrical representation. I am primarily doing research on different agencies based off of talent agencies that represent friends of mine or and I'm going to different shows on IMDB Pro and seeing which actors are represented by who and then within those talent agencies, which representatives represent those actors. So for example, right now I was working on Hentafide, which is on Netflix and it's a show I really, really like. Then it was cast by Carla Hul, which I've also made a video about her. If you guys want to check it out right there, I was seeing, you know, the actresses because there's a lot of Latina actresses on there and actors. And then I was going to those actress pages and seeing who they're represented by putting all of that information on my spreadsheet so that I have everything organized in one place. So when it does come time to send out those postcards or emails or however it is I'm going to be submitting to that specific casting agency or talent agency, I have everything in one place and I know, you know, where to go, what to do. So what I just did was I cut up some paper and then I wrote different things on these pieces of paper to get an idea of what I want to put on my spreadsheet just because I like this better than going on the spreadsheet right away because you have to delete it and then, you know, move it in a different place. So this I could physically move them around. I wrote different things like the location. So, you know, if it's LA and New York and Atlanta, then I can put that on there for when I seek representation in other places. I put the representative again because I want to know who in that talent agency represents that specific actor that I would also, you know, they're my type. So let's move to my computer and then we can create this spreadsheet together because this was my first step, making sure that I knew which order I wanted to put all of these things in. So when I go on Gmail and then go to Sheets and create my spreadsheet that I know where all of these are going to go. I'm going to share with you my screen and show you how I'm making this spreadsheet and then along the way, when I am putting something in each column, I'll let you know why I'm putting that there in particular. Today I'm doing it through Gmail. Then you're going to go to the top right where they have where there's nine circles over here and then scroll down to Sheets and I like a template that they already have on here. I tend to gravitate to the assignment tracker because I don't know. I already like the way that one looks. I'm just going to do that versus starting from scratch and I'm going to rename it as Spring 2021 Talent Agencies. Here I'm just going to make a note to myself. For the first one, I'm labeling it agency type and now the options for agency type are math, biology, geography. Obviously we want to change that. So I'm going to go up to B and I have selected that entire column and then I'm going to go to data and data validation and now we want to choose from a list of items and the items that I'm going to put for now are theatrical, commercial, voiceover. So the comma splits the different categories that you're going to choose from. So now these three come up and in the future I'm seeking representation for something else. I can just do the same thing and change it. Okay, so for the second one, I'm going to put the talent agency. So this would be the actual name of the talent agency and then just to put an example, it's going to be MDT and this one we're not going to put a list of different items because we're not going to choose it each time. It's just we're going to put it in each time. I'm going to make this smaller. The next one is location. This one I put LA, New York, Georgia and then for this one I put LA, New York and Georgia and this one LA and Georgia. Just what I'm going to put for now really right now I'm going to use mostly LA ones. This one's pretty straightforward. I would put the address, email, phone number, just anything that I might get my hands on and depending on what type of submissions they would like then that's how I'm going to reach out to them. I just want to have all of the information on my spreadsheet just in case something, I need one of those for any reason. The next one is going to be the show. So because most of these talent agencies that I'm submitting to are through something that I've watched before that their actors were in then I want to make a note like I was saying earlier hint if I is one that I'm currently doing research on. So I'm going to go ahead and just do that for show the actor that's in that show and the role that they played. So which character they played in that and now we're going to add some more to the right. So to keep adding them, you just want to control click for the for max and then you're going to just insert one to the right or to the left or whatever you want. Rep is going to be the specific representative for that actor in that talent agency because most agencies unless they're very very tiny the talent agencies have a lot of different agents that work there. So let's say there was an actress that I want you know her representative to also represent me within that agency then I know it was like you know Nancy Lopez or whatever I'm making this up obviously and then next I'm going to put the date that I learned this information. So for example if I'm on IMDB pro and I see that this actress is represented by Nancy Lopez I want to say okay it was on March 10th of 2021 that she was represented by this person because I don't want to submit to this representative in like two years and then she's like oh I haven't represented that actress in forever you don't know what you're talking about so that's the reason I'm putting that date there and then I just changed the data validation to date to different dates and then submission dates and then this way I know which day I actually submitted to them so if I need to follow up or if you know I need this note for whatever reason I'm just going to go ahead and put a future date just for the sake of this video and again I'll show you how I changed it you go to data data validation and then the list of you know ranges from list items there's actually a date option so I'm just going to do that and then make this a little bit smaller because this branch it's going to have a lot of information. The next one is submission type so this of course you need to see on their website or however you can find information for them list of items and it can be postcard email or online submission so some agencies have on their website a way that you can submit directly through their website. This one I'm just going to go ahead and say online submission rep submitted to so this is who I'm submitting to as we talked about earlier. Let's say the representative that I research was Nancy Lopez so then I would say here Nancy Lopez and I am not an expert at all with you know these spreadsheets I've only made a few and I've only used them you know for personal uses so some of this stuff I'm sure if you're an expert at Excel sheets spreadsheets you're like what are you doing like right now because I basically copied another road to the right it's giving me this we could clear it out if we wanted to if we wanted to be extra clean about it so this column I want to put if somebody referred me let's say somebody that's already represented by this agency if they referred me so I'll just put it a name just for fun you know if one of my friends actually put in a good word for me at that agency connection so this is in case I don't have anybody that can refer me to that agency which is going to be the most you know the most common that I don't actually have anybody referring me to that agency I can say you know somebody that we both have worked with or a project that we both have been a part of or something like that so this this one I'm just going to put Timothy Hulls you represent this person to or you've worked with him on this commercial whatever like some kind of what am I going to make that connection of you know I know about you because of this or you also represent a friend of mine whose name is this so just what kind of connection in case they don't have a referral at least I have some kind of connection or can tell them something about work that I like that they have done reply date so if they actually reply to me I just want to know if they did and when that was how long it took them for how long it took them to get back to me and then I'll just put April 1st meeting so this one did I get a meeting from them and for this one I'm going to edit it so it is a yes or no so I'm just going to say yes I got a meeting and lastly I am going to put notes so just anything if any any kind of anything that I want to write you know took the meeting but wasn't a great fit because and then I can put whatever notes or I can put it was a great meeting but they said you know they there aren't looking for somebody like me right now submit again in six months or whatever I can put those dates there but this is a spreadsheet I'm going to be using I'll probably modify it as I'm actually adding all of the information right now I just have everything in you know basically a Word document slash email where I was just copying and pasting all of the information so I might edit this I just wanted to show this to you guys this idea that I came up with put it gathering everything together on a spreadsheet I'm telling you exactly how I'm doing it so you can do it as well you can create a spreadsheet let me know if there's anything else that I should be putting on here any other column any other information that might be useful for me if you want to learn more about my submission process and all of that I do have a few videos already on agents talent agencies you can watch those and I will be adding more and more and at the end of every video I feature another channel this is today's feature if you would like to be featured on my next video make sure you're subscribed like this video and leave me a comment.