Uploading data from amoCRM google sheeets

Welcome. There is a task - to develop a script.
the application is given access according to the new api.
In the Google table, insert into the cells of the URL filter from amoCRM with 1 parameter (quantity or sum)
well, this data should be pulled up from amoCRM
there will be a lot of filters and cells.
example. inserted a formula into a cell

=HYPERLINK("https://sdfghjk.amocrm.ru/leads/list/?filter[pipe][3704569][]=142&filter[pipe][3704569][]=143&filter[pipe][3704569][]=35990908&filter[pipe][3704569][]=35990941&filter[pipe][3704569][]=35990944&filter[pipe][3704569][]=35990947&filter[pipe][3704569][]=38255731&filter[pipe][3704569][]=38255734&filter[pipe][3704569][]=38255737&filter[pipe][3704569][]=38255740&filter[tags_logic]=or&filter[main_user][]=7118527&useFilter=y&filter[cf][ 463005][from]=01.05.2021&filter[cf][463005][to]=01.05.2021"0)


the value for the number of transactions has been pulled up. if parameter 1 - then the value by sum

Do NOT go astray in the amo. there should be no blocks on api.
It is necessary to take into account a really huge number of cells with such formulas.


PAYMENT ONLY AFTER SUCCESSFUL DELIVERY OF THE PROJECT.
Min advance is possible.
It is preferable to work with individual entrepreneurs