0:00 Hey everyone, today we'll be taking a look 0:02 at Sheets to API. 0:03 It can turn any spreadsheet into an API. 0:06 If you're a developer, you're already familiar 0:09 with the usefulness of this tool. 0:11 So imagine you're building something like a no-code tool 0:14 or some type of a website or backend 0:16 and you have a massive Google Sheet. 0:18 For example, I have a big database of backlinks 0:22 and to use this type of database, 0:25 you need something like an API to use it in your app. 0:28 Which would be very useful. 0:29 So this app is gonna be very useful 0:32 for those types of people who are looking for it. 0:34 Usually, I imagine the search term is gonna be something 0:37 like a Google Sheet that people look for. 0:40 And then you see a bunch of examples, 0:41 for example, Sheety. 0:42 It can turn your Google Sheet into an API. 0:45 We have SheetsDB.io and we have Google Sheets API, 0:50 GitHub over here. 0:51 And finally we have our target, Sheet2API.com. 0:55 They have the main rating of 30 0:57 and about 240 backlinks with a search traffic of 72. 1:03 This means about 70 clicks go to their website every month. 1:08 The competitors are a little bit higher. 1:11 They have a little bit higher domain rating. 1:12 So at 47, we have a few more backlinks, 1:15 about 1,865 search traffic, SheetsDB. 1:19 And the other one, Sheety.io.co has about 40 domain rating 1:24 with less or a similar amount of backlinks. 1:27 Maybe they're a bit more powerful 1:28 and a little bit less of search traffic. 1:31 So let's take a look and dive deeper in here. 1:34 Except for the YouTube videos, 1:36 these seem to be the only results here on Google. 1:40 And the first thing to check is the Ahrefs results 1:45 for Sheet2API.com to see what we're working with. 1:49 Again, we can see that their traffic 1:52 has been going down over this time 1:54 and they mostly get traffic now from India, 1:56 United States, and Brazil. 1:58 The keywords that they're ranking for seem to be SheetDB, 2:02 which is one of those competitors we saw just now, 2:05 same Google Sheet as CSV. 2:08 And if we check the top pages, 2:10 we have a blog post, how to convert a Google Sheet to CSV, 2:14 and also an Excel Sheet to JSON API. 2:17 So Excel Online API, Google Sheet as CSV, 2:22 how to convert Excel to Google Sheet, 2:23 Google Sheets API Python, 2:25 how to embed a Google Sheet into a website, 2:27 all very useful. 2:28 And they seem to have a few document types. 2:32 So they have documentation, 2:34 which has the information like SheetDB versus Sheet2API. 2:37 That's how they're able to rank for competitors. 2:39 And they have this all the way in the footer. 2:41 And also blog posts. 2:43 So you can write a high quality blog post 2:45 and explain people how to use something. 2:47 Then you have the homepage. 2:49 Then we have Excel Online as a REST API, 2:52 which seems to be similar to a blog post, 2:55 but it seems to be a little bit more different 2:58 in a different format. 2:59 So potentially this is part of the use cases table, 3:02 and it has a bit of different type of information. 3:05 Potentially they wanted to cover this 3:07 to cover more types of keywords 3:10 and different types of structures. 3:11 So here we see that they don't have a canonical URL 3:14 and that they should enable. 3:16 And we have the title over here, which is correct. 3:21 Spreadsheet as CMS. 3:22 They have three different parts, 3:23 which they sliced up in web columns. 3:26 And then we have the description, 3:28 which is a little bit short, but good enough. 3:30 But Spreadsheet as CMS as an example. 3:32 The first example that we're looking at 3:35 is Excel Online as a REST API. 3:37 And here we see a bunch of examples. 3:39 I feel like this title is way too long. 3:41 It needs to be about 60 ideally, 3:44 because if someone types in Excel Online Spreadsheet 3:46 as a REST API, it's way too long. 3:48 The way that you try to focus on this is get hrefs. 3:52 And then you can take a look at your blog posts 3:55 or articles one by one 3:56 by matching for the exact URL over here. 3:59 And then you see what keywords this page is ranking for. 4:01 Once you see this, that once sorted by volume, 4:05 these are potentially the biggest keywords 4:07 that are ranking or potentially could rank for this page. 4:10 Excel Online, of course, it doesn't make sense. 4:13 So you have to scroll down a little bit 4:14 and see which one does. 4:15 Maybe it's Excel API. 4:18 Maybe it's Excel to JSON Online. 4:20 Maybe it's an API for Excel. 4:22 But all of these have huge amount of volume. 4:25 So if we take a look at the articles 4:29 or the keywords that are in position one to 10, 4:31 the best one seems to be Excel Online API. 4:34 And if you look for this, 4:35 we do see that we have a few different things here. 4:37 Microsoft is ranking here. 4:38 Stack Overflow is ranking here. 4:41 Some ways that you could do this is comments. 4:43 Also, a link to your own website on Stack Overflow. 4:48 Otherwise, we have Revit API, which is popular. 4:50 And finally, Sheets API. 4:52 There is the title that we see here. 4:54 It's Excel Online Spreadsheet as a REST API 2024. 4:57 Is this exactly the same as this one? 5:01 Yes. 5:02 So the thing that is being cut off here 5:03 is Sheet API, Google Sheet REST API. 5:06 I would probably remove this part of the template 5:09 and only keep this beginning part 5:11 because this one doesn't make sense. 5:13 You're talking here about Excel Online, 5:15 but also you have Google Sheets and Sheet API. 5:18 You don't really need to include this 5:20 in every part of your title. 5:21 It's not always mandatory. 5:23 That's part of the quick thing 5:26 we can improve for on-page SEO. 5:28 The blog posts seem to be similar, 5:31 missing canonical reel, 5:33 and also has the suffix in the end. 5:37 The H1, H2, H3 is all good, 5:40 and it seems to be correct. 5:41 Probably the thing that you want to do 5:43 is take a look at your articles, Google them, 5:45 and see what else is ranking for the specific search term 5:49 that you're also ranking for. 5:52 And then see who has potentially better results than you. 5:55 So this one was the top four article, 5:59 how to convert Excel to Google Sheets. 6:02 I don't think it will convert super well 6:04 if you get traffic to this, 6:05 but still, okay, sure, you want to get some traffic. 6:08 Here, get Ahrefs, take a look at the keywords 6:11 that you're ranking for, 6:12 and then you can finally see 6:14 how to turn Excel into Google Sheets. 6:16 Potentially, if Ahrefs and Google is telling you, 6:19 okay, this is a better position than the other ones, 6:21 and the volume is pretty big, 6:24 if we sort by volume over here, 6:26 convert Excel to Google Sheets, 6:28 how to convert Excel to Google Sheets, 6:30 maybe we can, if people are typing in this exactly, 6:33 and the volume is higher, 6:35 I think you can change this title, for example, 6:37 how to convert Excel to Google Sheets, 6:39 and remove this word over here, 6:41 and this will match exactly the keyword 6:43 that people are looking for. 6:45 So if we look at the keyword itself, 6:47 we see that we have a bunch of results, 6:49 and you are none of them. 6:53 And the thing that you ideally should do 6:55 is Google this item, 6:57 and see what type of results that we get. 7:00 Okay, Google Help is one of the first ones. 7:03 The other strategies that you can do here 7:04 is make a video over here, 7:06 and your video could be something simple, 7:09 but you go through the results, 7:11 you maybe show your app and how it works, 7:13 and then people can see, okay, nice, 7:15 this is exactly how our app works. 7:17 The other articles seem to be very high domain rating, 7:19 70, 71, 62. 7:21 Here is 147, that's a little bit lower. 7:24 But otherwise, it's gonna be a little bit difficult 7:26 to rank over here, 7:27 and the thing that you would have to do 7:29 is get a bunch of backlinks. 7:31 I made a tweet recently 7:33 that shows exactly where to get backlinks from. 7:36 So there's these three platforms, 7:39 you go over here, 7:40 and then you select something that is familiar for you. 7:43 For example, you search for something like Sheet, 7:48 or Google, 7:50 and then you see that Fresh Google News, 7:52 you can buy a backlink for $160, 7:54 and then they write an article for you, 7:56 and you get a backlink to this page. 7:58 And because, I'm saying this 8:00 because you don't really have any blog posts, 8:02 backlinks to your blog posts. 8:03 For example, if you filter only, 8:05 the blog is doing a little bit better than before. 8:07 It went from zero to 22 in the recent months. 8:10 But if you filter on the amount of backlinks that you got 8:12 for just the entire blog, 8:14 not only the homepage, 8:15 there's only three. 8:16 Indie Hackers, SaaS Hub, 8:18 Knishy's Shop, and that's it. 8:20 So the easiest way to rank all your pages higher 8:23 and actually start getting more traffic 8:24 for your valuable blogs 8:26 is to start getting a little bit more 8:28 of backlinks over here. 8:29 And I think this will help you out quite a lot. 8:33 So take a look at this 8:34 and see if that makes sense. 8:35 Otherwise, I think one exercise that we can do for you 8:39 is taking a look at the competitive analysis. 8:42 And if we type in your URL over here, 8:44 and then some of the competitors like Sheet.co, 8:47 which we're ranking for the keywords 8:49 that we were looking for earlier, 8:51 you'll see some of the pages that they also rank for 8:55 if you filter on Google. 8:57 So Sheet.io and Sheet.db, 8:58 they're all both ranking for Google Sheets API documentation 9:02 and WordPress Sheets. 9:03 So Sheet.db is outranking you mostly on Google Sheets API. 9:07 And this is the most, the highest volume keyword. 9:10 The other ones are Sheets API, Google Spreadsheet API, 9:12 Sheet.db, and API for Google Sheets. 9:15 So these seem to be the highest targets 9:16 that at least one competitor is ranking in the top 10 for. 9:20 The thing that you can also do 9:22 is take a look at the referring pages 9:25 and see where they get the most traffic from. 9:28 That is a backlink. 9:29 So Sheet.db.io gets a lot of, 9:32 I will include this for you in a Google Sheets, 9:36 and I'll attach this to the Notion document 9:39 that I'll send later for the audit. 9:41 But here you get an entire exploit, 9:43 and you can see that, okay, 9:44 Sheets.db is getting a lot of page traffic 9:46 and they have a real backlink from GitHub. 9:48 For example, public APIs. 9:50 If we open this up, let me clean this up 9:52 and show you how to go through this yourself. 9:56 For example, we have referring pages. 9:58 Okay, this is the title. 9:59 This is the GitHub. 10:01 And here we have the language. 10:02 Okay, we can ignore all of this. 10:04 Not super important. 10:06 We have the domain rating. 10:07 We call this the R instead, 10:10 and then put this in the center. 10:13 URL, also important is the URL ratings 10:16 for this specific page. 10:17 Domain traffic in total, 10:19 the amount of backlinks that they have to this page, 10:22 and the traffic to this page, 10:25 which we call page traffic. 10:27 The intersect is how many potential results 10:30 we have over here. 10:31 If I turn on conditional formatting 10:35 and say, okay, if the number is equal to zero, 10:40 let's hide this result. 10:42 So just make it white 10:43 and make the text also white. 10:47 Here we go. 10:49 Nice. 10:50 So now we see, okay, 10:51 Sheets.db has a backlink from this page 10:54 and you, for example, don't. 10:55 I think you don't. 10:56 This is excluded, 10:57 so you always don't have this traffic. 10:59 So this is sorted by priority by page traffic. 11:02 So these are the best backlinks for Sheets.db 11:04 and Sheets.co. 11:06 What I would do is add a column over here 11:10 and say something like, 11:12 oh, let's do it the opposite way. 11:14 Add a column over here 11:19 and say done. 11:22 And then once you've done this, 11:24 once you've gone through the link and, 11:25 okay, I have the public API for free, 11:28 where let's see where is Sheets.db. 11:30 Sheets.db has a backlink here. 11:33 If we take a look over here, 11:35 no, we don't see it on this page, 11:37 but it's potentially hidden somewhere. 11:38 But in any case, 11:39 you can add your list here by editing the readme 11:43 and I believe potentially you could be included 11:45 if you have some type of result. 11:48 Then the other one is Simplified Chess, Queen's Gambit. 11:52 Seems to be some type of random blog post, 11:55 but Sheets.db somehow has a backlink here 11:57 or it's being used as some part of the result. 12:01 The other ones as well, Simplified Chess, 12:03 all of these, Sky Route, Launch Services, 12:06 Redbox, Estates. 12:08 Let's take a look. 12:09 I believe these are actually a little bit different 12:11 types of results that we usually get 12:13 because they're probably getting results via JSON 12:16 and that's why Google finds these as a result. 12:19 Let me take a look and see if this is correct. 12:25 Redbox, backlink over here. 12:30 All right, there's a, oh yeah, okay. 12:32 It's using the Sheets.db API. 12:33 So actually I did something else. 12:36 I gave you an entire result 12:38 where these pages are potentially clients. 12:41 So this is even better. 12:42 Go to this list and see if they're using the API 12:47 for Sheets.db and then you can reach out to them. 12:53 So let me give you a better result 12:56 because this one doesn't make so much sense. 12:59 Sheets.db, okay, they have the amount of backlinks. 13:03 We can filter them on the, 13:05 if the backlink type of the referring page URL 13:08 has the word API. 13:12 So these are being counted as some type of API usage, 13:16 right, target URL, if it has the API in the word. 13:20 So this is a list of clients. 13:23 We have one link per domain. 13:24 And now you know everyone who is using Sheets.db.io 13:28 in their backend. 13:29 So this is very powerful. 13:30 You can export this list. 13:32 This is the power of backlinks. 13:34 And Google knows this and Ahrefs knows this. 13:36 And now what you can do is actually go 13:40 make a campaign like this. 13:42 Now you find, for example, using Hunter. 13:44 You go here, you type in a finder. 13:47 You do like a domain search for Simplify Chess. 13:51 Now, simplifychess.com, skyroot.in. 13:56 All right, we have skyroot.in. 13:58 We find the email addresses, the co-founder. 14:00 And then you write an email and say, 14:02 hey, by the way, I saw you're using Sheets.db.io. 14:06 What about if we give you a discount to Sheets.2API? 14:09 And this would potentially be a very easy way 14:12 for you to do cold email outreach. 14:14 So this is what kind of what we do at our backlink service. 14:18 But now it has a schemas for you for your backlinks. 14:22 So all of these are customers for Sheets.db. 14:24 So just email everyone by using something like Hunter. 14:27 I'll add an affiliate link in the report as well. 14:30 Take a look there and email everyone 14:32 and potentially have a few more customers. 14:34 So that's a different segue than SEO, 14:37 but it's part of SEO because many people don't know 14:40 this is possible and this leads to a way 14:42 of getting a backlink. 14:44 And because they're getting a lot of domain backlinks 14:46 and domain rating, this can be abused in this way 14:50 or cleverly used to do competitive B2B SaaS SEO. 14:54 All right, good luck.
https://github.com/public-apis/public-apis
Hunter.io to find email addresses for decision-makers at these companies
