Analogue of a database in Google sheets?

Question

Google Sheets

Hello! The task is to send price lists to customers.
Is there any solution for Google Sheets where it will be possible to change data and prices for tables somewhere in one place without opening them?
For example, some one table where the data for all tables is stored - and the other pulls it up from there?

Answer 1

Without coding, you can take advantage of the Spreadsheet publishing feature. In that published Table, data can be obtained via IMPORTRANGE from other Tables.
Be careful, if you grant access to someone for editing, then through IMPORTRANGE he will be able to get the entire data array of the first sheet and the sheet you referred to in the formula.
But I would recommend a programmatic way of distributing data. For example, through Apps Script or any other tool, fortunately, the standard library of the Google API is wide.

Answer 2

There are many sheets within one book. One sheet can link to another.
Also in Google sheets you can access api through GScript