M
M
Mr.2020-09-25 19:41:46
Google Sheets
Mr., 2020-09-25 19:41:46

Can data be imported?

Site - https://mangalib.me/i-alone-level-up
What needs to be imported

5f6e1bdd11e1d543520232.png

I only need to import the number 119.

Experience - Spent 6 months but I can't figure out how.
Questions - Is it possible to import from this site at all. If there are other ways to import.
The site where all my formulas are - https://docs.google.com/spreadsheets/d/16rX9mhuwph...

If something is missing, write right away.
And yes, I'm not 100% sure that there are no Table and List. Personally, I didn't find it.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2020-09-25
@ForestAndGarden

It is possible to read through RSS, but it does not work directly. The impression is that requests from foreign IPs are blocked.

  1. Install on domestic hosting Tiny Tiny RSS,
  2. enable Cron for auto-update,
  3. subscribe to the RSS generated by the site,
  4. get a feed link (RSS) created by Tiny Tiny RSS,
  5. add the received link to Feedburner and get a new one from it,
  6. use the IMPORTFEED function.

To get just the number, use unary negation, RIGHT function, query "items url" in IMPORTFEED. Voila.
=--RIGHT(IMPORTFEED("ссылка_на_рсс";"items url";;1);3)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question