FINALLY!! I've been waiting for this for years. This is one of the major functions that Microsoft excel had over sheets. Tools - Record. Then playback to repeat what you just did. The possibilities are endless. No instruction needed just imagination.
Great stuff man. I know the video is seriously old for me to give my input, but I started using google data studio to create dashboards and reports for me and for clients, and dam! Its amazing
Oh, sorry, didn't mean to say that the strategy was old. Just that the video is close to being 2 y.o and perhaps giving an input on it now wouldn't be as relevant. But it is good to know that you guys are still working with it. I would be interested to see a more in-depth of how it works since on this video you couldn't show more details because of sensitive information.
Fantastic video. Thanks for sharing Ryan! I've been looking for inspiration and I found it in your videos. I have about 40 clients, use GSuite, but am always looking for that next piece of software that will solve all my problems, and deep down I know Google Sheets / Excel is the most powerful tool. I must submit myself to stop chasing the shiny object and just put a system in place that works and stick with it.
I loved this one Ryan...Thanks a bunch for all the valuable information. I use sheets on a daily basis. This would be a huge asset for anyone who gets it!
Insightful content! Can you please focus more on beginners (project managers). I find your explanations too complex to comprehend. If there's a step-by-step masterclass for this, Kindly drop the link. Thanks
I am with you on Google sheets. I used Excel From when they started.Yes Excel has a lot of bells and whistles. The main thing that turned me into google sheets was the real time sharing. I have been using Google sheets for the last 5 years. The only problem is you get to much data it slows way down and takes time to load. All them sheets you showing Are just basic data pulling. You give me a data base and you tell me what you want pulled it is easy. I do it all the time for my business. I stopped using Excel. I needed info in in real time. Not for some one to send the info and then encode. The person doing the job will encode the info and I have it.
Hi, Thanks for the great video. I have 2 Google sheets files using the same template[which means the column names are same in both of them]. But they contain different records/data. How do I find the difference between them in an easy, quick way? Regards
Hi, Thank you, for the video!!! Am getting started soon, should I Implement something similar but just on a smaller scale to get started? what would you say are the most have for beginners?
I'm not sure when the last time you used Excel, but most of the pros you gave sheets, excel has as well and there's a ton of support on the msdn site alone. Not hating, I've considered learning GS (script not sheets) numerous times now. However, now I don't feel it's as important as I'm sure most business still use the office suite over google.
I use Excel limitedly. In our experience, Sheets is better for a lot of reasons - our entire organization runs on Drive, Excel has benefits but not for enterprise level organizations
@@NOTRyanStewart I'd say that was an inaccurate statement. Excel was designed for enterprise level. Not trying to be rude, I would just say you didn't know how to utilize it. Which is understandable. Sheets can be much more user friendly to someone who doesn't know either so I can see how a company could trend in that direction. I know several that do use it, just more use office.
Hi I have a question please help me. I have the below google script to movew cells after i put i word for instance once I say "ok" then the row will be moved into another sheet based on my confirmation as I have wrote "ok", but I want to add another word beside "ok", for instance I want to have two words "ok'' or "confimed'' to do the same thing, i have been working on it since two days but I can't execute this function; I don't any videos on youtube as well to show how to run different/ multiple google scripts in one sheet. below is the script just tell how can i add another word beside the ''ok''. Thanks in advance. Please replay me back ASAP. I really need to complete it by the end of this month. /** * Moves row of data to another spreadsheet based on criteria in column 6 to sheet with same name as the value in column 4. */ function onEdit(e) { // see Sheet event objects docs // developers.google.com/apps-script/guides/triggers/events#google_sheets_events var ss = e.source; var s = ss.getActiveSheet(); var r = e.range; // to let you modify where the action and move columns are in the form responses sheet var actionCol = 1; var nameCol = 4; // Get the row and column of the active cell. var rowIndex = r.getRowIndex(); var colIndex = r.getColumnIndex(); // Get the number of columns in the active sheet. // -1 to drop our action/status column var colNumber = s.getLastColumn()-1; // if our action/status col is changed to no do stuff if (e.value == "ok" && colIndex == actionCol) { // get our target sheet name - in this example we are using the priority column var targetSheet = s.getRange(rowIndex, nameCol).getValue(); // if the sheet exists do more stuff if (ss.getSheetByName(targetSheet)) { // set our target sheet and target range var targetSheet = ss.getSheetByName(targetSheet); var targetRange = targetSheet.getRange(targetSheet.getLastRow()+1, 1, 1, colNumber); // get our source range/row var sourceRange = s.getRange(rowIndex, 1, 1, colNumber); // new sheets says: 'Cannot cut from form data. Use copy instead.' sourceRange.copyTo(targetRange); // ..but we can still delete the row after s.deleteRow(rowIndex); // or you might want to keep but note move e.g. r.setValue("moved"); } } }
please dont come on here making demands about what you think i should do for you. i dont owe you anything. you want my help by the end of the week? pay me. if not, enjoy the free content and move on
Thank you very much for the video, ideas and template. I have a doubt: when you generate the sheet for the client, is that sheet editable by client or just an informative sheet? I mean, I know how to export just the rows for one client from the master project sheet, but the client's sheet wouldn't be editable, just informative and I don't know if you got to make it editable. Thanks!
Cool Video! I was thinking of Starting a Link building Small Agency (for now) followed your links and watched the demo (awesome!). About how far into depth does your videos go? Pricing for services and such?
Thanks for loading up the replay. The download page is currently empty and the email capture form says email addresses are invalid. Guess you're still in the process of setting this up?
Hi Ryan, nice vid! I’m doing similar as you and you forms to capture orders etc. I use pivot tables to create dashboards and overviews but find it slows google down tremendously, takes up to 20 seconds to refresh, any advice?
Great post… but no content audit template available via your tools page & the content-audit page errors out when clicking the “give me template” button
Hey Ryan, My nickname for you is the kitchen-sinker becuase that is what you're always giving away. My question is, "How do you pitch your services as a beginner to start getting clients for your own marketing firm starting from the ground up?" Thanks.
You have link says download these free tools but its just showing the main site and 2 free downloads but neither of which is what you talked about here.
Total waste of time. I just got suckered into watching a guy brag about all his clients instead of actually showing us how to automate in Google Sheets.
Seriously if people followed someone like you they could build as well functioning agency and do good work. Instead of the b.s guru nonsense out there.
Disculpa pero fue más bla, bla que compartir conocimiento. Y en lo que respecta a la negatividad te aclaro que todos tenemos mucho de positivos y poco de negativos. Lo contrario es cuestionable.
FINALLY!! I've been waiting for this for years. This is one of the major functions that Microsoft excel had over sheets. Tools - Record. Then playback to repeat what you just did. The possibilities are endless. No instruction needed just imagination.
Glad you agree!
Great stuff man. I know the video is seriously old for me to give my input, but I started using google data studio to create dashboards and reports for me and for clients, and dam! Its amazing
its not old! this info is evergreen, it still (and will) be the cornerstone of how we run our agency
Oh, sorry, didn't mean to say that the strategy was old. Just that the video is close to being 2 y.o and perhaps giving an input on it now wouldn't be as relevant. But it is good to know that you guys are still working with it. I would be interested to see a more in-depth of how it works since on this video you couldn't show more details because of sensitive information.
This is one of the most valuable videos I've ever seen online... WOW! Well done.
Wow, thanks!
Fantastic video. Thanks for sharing Ryan! I've been looking for inspiration and I found it in your videos. I have about 40 clients, use GSuite, but am always looking for that next piece of software that will solve all my problems, and deep down I know Google Sheets / Excel is the most powerful tool. I must submit myself to stop chasing the shiny object and just put a system in place that works and stick with it.
for sure! we have a newer video on this process, you can check it out here: theblueprint.training/seo-project-management/
Really like the transparency you give your clients. Ive worked for 4 seo agencies and left them due to them *milking clients. Not my type of thing
glad you enjoyed it Scott :)
holy shit I did not understand a thing he said... I don´t think this will qualify for me as a quick side job.
I loved this one Ryan...Thanks a bunch for all the valuable information. I use sheets on a daily basis. This would be a huge asset for anyone who gets it!
thank you! and youre welcome :)
Great Info and process. Brings it all in one place.
Glad you think so!
Insightful content!
Can you please focus more on beginners (project managers). I find your explanations too complex to comprehend.
If there's a step-by-step masterclass for this, Kindly drop the link.
Thanks
ill see what i can do!
Great video, I really learnt alot
Glad it was helpful!
I am with you on Google sheets. I used Excel From when they started.Yes Excel has a lot of bells and whistles. The main thing that turned me into google sheets was the real time sharing. I have been using Google sheets for the last 5 years. The only problem is you get to much data it slows way down and takes time to load. All them sheets you showing Are just basic data pulling. You give me a data base and you tell me what you want pulled it is easy. I do it all the time for my business. I stopped using Excel. I needed info in in real time. Not for some one to send the info and then encode. The person doing the job will encode the info and I have it.
Agreed, Excel is a powerful tool but Sheets is a a more practical solution for today's marketer
Any tips for slow gsheets that are pulling lots of data down using importhtml?
Good stuff! That link doesn't lead to a download page though. Will those files be there soon?
It's up and running now: webris.org/tools/project-management/
A lot of gold nuggets in this.
This automation work is beyond beautiful
Can you give me the link to this sheets?
1. Client management and onboarding
2. Project management
its not under your link.
webris.org/tools/project-management/
Thank you for giving another overview of the power of GoogleSuite
Happy to see I'm not the only gsheet fan :p Sorry Hubspot
I hate to poke the giant, but yeah, not a fan of the product at all
wow
bro
Hi,
Thanks for the great video.
I have 2 Google sheets files using the same template[which means the column names are same in both of them]. But they contain different records/data. How do I find the difference between them in an easy, quick way?
Regards
:)
Do you have to pay monthly gsuite for each outsoured worker
Hi, Thank you, for the video!!! Am getting started soon, should I Implement something similar but just on a smaller scale to get started? what would you say are the most have for beginners?
Just start playing with Sheets more, the opportunities will present themselves.
Hey Ryan, just dropping in the see when the Google Sheets would be available to check out? I didn't see them in the link from the video description?
It's live: webris.org/tools/project-management/
I'm not sure when the last time you used Excel, but most of the pros you gave sheets, excel has as well and there's a ton of support on the msdn site alone. Not hating, I've considered learning GS (script not sheets) numerous times now. However, now I don't feel it's as important as I'm sure most business still use the office suite over google.
I use Excel limitedly. In our experience, Sheets is better for a lot of reasons - our entire organization runs on Drive, Excel has benefits but not for enterprise level organizations
@@NOTRyanStewart I'd say that was an inaccurate statement. Excel was designed for enterprise level. Not trying to be rude, I would just say you didn't know how to utilize it. Which is understandable. Sheets can be much more user friendly to someone who doesn't know either so I can see how a company could trend in that direction. I know several that do use it, just more use office.
@@FoX84tac022 excel is 10 years behind, they only developed array formulas 3 months ago...
Hi I have a question please help me. I have the below google script to movew cells after i put i word for instance once I say "ok" then the row will be moved into another sheet based on my confirmation as I have wrote "ok", but I want to add another word beside "ok", for instance I want to have two words "ok'' or "confimed'' to do the same thing, i have been working on it since two days but I can't execute this function; I don't any videos on youtube as well to show how to run different/ multiple google scripts in one sheet. below is the script just tell how can i add another word beside the ''ok''. Thanks in advance. Please replay me back ASAP. I really need to complete it by the end of this month.
/**
* Moves row of data to another spreadsheet based on criteria in column 6 to sheet with same name as the value in column 4.
*/
function onEdit(e) {
// see Sheet event objects docs
// developers.google.com/apps-script/guides/triggers/events#google_sheets_events
var ss = e.source;
var s = ss.getActiveSheet();
var r = e.range;
// to let you modify where the action and move columns are in the form responses sheet
var actionCol = 1;
var nameCol = 4;
// Get the row and column of the active cell.
var rowIndex = r.getRowIndex();
var colIndex = r.getColumnIndex();
// Get the number of columns in the active sheet.
// -1 to drop our action/status column
var colNumber = s.getLastColumn()-1;
// if our action/status col is changed to no do stuff
if (e.value == "ok" && colIndex == actionCol) {
// get our target sheet name - in this example we are using the priority column
var targetSheet = s.getRange(rowIndex, nameCol).getValue();
// if the sheet exists do more stuff
if (ss.getSheetByName(targetSheet)) {
// set our target sheet and target range
var targetSheet = ss.getSheetByName(targetSheet);
var targetRange = targetSheet.getRange(targetSheet.getLastRow()+1, 1, 1, colNumber);
// get our source range/row
var sourceRange = s.getRange(rowIndex, 1, 1, colNumber);
// new sheets says: 'Cannot cut from form data. Use copy instead.'
sourceRange.copyTo(targetRange);
// ..but we can still delete the row after
s.deleteRow(rowIndex);
// or you might want to keep but note move e.g. r.setValue("moved");
}
}
}
please dont come on here making demands about what you think i should do for you. i dont owe you anything. you want my help by the end of the week? pay me. if not, enjoy the free content and move on
@@NOTRyanStewart thnx for ur rude response, but i am gonna find it by myself and will do whatever I want to do.
Great job! I love what you have done with this concept. Thank you!
Thank you!
What do you use to automate the reporting process via semrush / GA ?
Supermetrics
nice overview of your google sheets process - what a difference to my haphazard way of organising (like a 1000 times difference lol)
awesome! we're glad you enjoy it :)
Thank you very much for the video, ideas and template. I have a doubt: when you generate the sheet for the client, is that sheet editable by client or just an informative sheet? I mean, I know how to export just the rows for one client from the master project sheet, but the client's sheet wouldn't be editable, just informative and I don't know if you got to make it editable. Thanks!
It's editable if you want it to be
Good tut on what can be done in sheets
“I bet you’d like to see that wouldn’t you?” *hits pause. I would be so fired for showing client data on a public facing video.
:)
Cool Video! I was thinking of Starting a Link building Small Agency (for now) followed your links and watched the demo (awesome!). About how far into depth does your videos go? Pricing for services and such?
They go all the way down - everything you could possibly want to know!
Thanks for loading up the replay. The download page is currently empty and the email capture form says email addresses are invalid. Guess you're still in the process of setting this up?
Fixed it, webris.org/tools/project-management/
I could not find sheets to download from webris link provided
Working now: webris.org/tools/project-management/
Hi guys , Your website looks really nice and fresh , unfortunately we can not still download the Sheets . Hope you can make done for us.
Sorry about that, it's working now: webris.org/tools/project-management/
Looks like you need developed a personalized software to fit your business needs :P
loooooool, yeah let's do that and create some issues for ourselves
Can we apply formula automatically to every new entry into the sheet
yes
Hi Ryan, nice vid! I’m doing similar as you and you forms to capture orders etc. I use pivot tables to create dashboards and overviews but find it slows google down tremendously, takes up to 20 seconds to refresh, any advice?
use bigquery instead
Great post… but no content audit template available via your
tools page & the content-audit page errors out when clicking the “give me
template” button
Worked out the bugs, working now: webris.org/tools/project-management/
This is amazing. But I couldn't see the tools you mentioned here in the site. I love what you did her :D
Finally up and working: webris.org/tools/project-management/
When will the template/google sheet be avable?
webris.org/tools/project-management/
by "rebranding" you must mean copy someone else's work without attribution and slap your logo on the top
not sure what you're insinuating...
do you have a service where you set this up for us?
we do, drop ryan an email - ryan @ webris dot org
Email sent ryan!
Working with PAKISTANI people. That's amazing
we got love for everyone, doesnt matter where youre from!!
@@NOTRyanStewart kia Baat hai
Using the Google Suite heavy, 😊!!!
yessirrrrrrr
Awesome Ryan. Liked it and watched right through. Same as other comments mate, keen to get access to those sheets :-)
coming soon!
It's live now: webris.org/tools/project-management/
Do you have public templates of tjese docs/sheets
We do: webris.org/tools/project-management/
Thanks for the video! Really useful inspiration!
You're welcome Tim!
Hey Ryan,
My nickname for you is the kitchen-sinker becuase that is what you're always giving away.
My question is, "How do you pitch your services as a beginner to start getting clients for your own marketing firm starting from the ground up?"
Thanks.
thanks martin! glad you enjoyed
You have link says download these free tools but its just showing the main site and 2 free downloads but neither of which is what you talked about here.
We're going through a reorg, stand by!
Total waste of time.
I just got suckered into watching a guy brag about all his clients instead of actually showing us how to automate in Google Sheets.
He says at the beginning "this is not a technical tutorial". What'd you expect bud?
Sorry you feel that way Danny, we do what we can to help - sorry we didn't meet your expectations
Again, apologies for wasting your time
@@NOTRyanStewart don't apologise, was an awesome tut as usual
It took you 22 mins to figure that out. Don’t be a bitch. Use the internet.
Can you do everything you can do on Asana on Drive?
no, they're much different platforms and systems, thats why we built something custom in google sheets
Hope you could make one for tick boxes (multiple choices)
Using Data Validation, Ryan teaches it all here: webris.org/tools/project-management/
Thank you, sir!
You're welcome!
You're welcome!
Hello Sir,
I need Your help for, How to integrate API in Google Sheets.
Why do all people from India call people sir?
Seriously if people followed someone like you they could build as well functioning agency and do good work.
Instead of the b.s guru nonsense out there.
thank you!!! tell yo friends :)
@@NOTRyanStewart Haha deffo will!
What is ur email? I want to send you a Word Doc.
why...
What do u mean by links :(?
www.wordstream.com/link-building
Someone has an all in one SEO Sheets to share ??
We've got a bunch here: webris.org/tools/
tool link not working
It's working now: webris.org/tools/project-management/
we can't download anything ur page seems broken
Working now: webris.org/tools/project-management/
wheres the "automation"?
It's all here: webris.org/tools/project-management/
Perhaps you shouldn't show emails of your clients to everybody on TH-cam. )
:/
Why not just use Trello?
We prefer Sheets, just a preference
#webProjectManagement #GSuite #GoogleDocs
hashtag gang!!!
Did anyone buy his templates? Please share it with me...
Na dude that's not cool - they're cheap, pony up the cash
waste of time
Well ok then
I am new , love your videos. Iam sell in fiverr, can help ? :)
thank you!
too much talk, not enough instruction
ok...
Too much swearing - very unprofessional
shit ... sorry!
@@NOTRyanStewart that is funny
pésimo puro bla, bla, bla
gracias por tomarse el tiempo para compartir su negatividad con el mundo. vuelve al sótano de tu madre
Disculpa pero fue más bla, bla que compartir conocimiento. Y en lo que respecta a la negatividad te aclaro que todos tenemos mucho de positivos y poco de negativos. Lo contrario es cuestionable.
Bullshit !
k
This seemed like a great resource. Had to stop watching...can't deal with the cursing.
apologies greg, ryan is who is who is.
Shame you might have learnt something
lol, the only part that made it worth while