Creating a formula for automatically uploading information from Bitrix24 to Google Tables via the Bitrix API for your managers.

This solution is suitable for those who:

He wants to quickly and correctly receive data from Bitrix24 directly into your Google Spreadsheet for further processing (reports, calculations, analytics, etc.).
He does not want to constantly pay for a subscription to the desired application or access to the marketplace.
Who does not have enough standard application functionality for unloading (The CTRL+C and CTRL+V method is time-consuming and does not bring the desired result)
Who needs complex unloading (For example: goods from transactions of a certain stage)

The upload is managed in the form of a formula, where you put your Bitrix24 link and the secret authorization code you created.


Need to order:

To perform the task promptly, it is necessary:

The link you generated indicating the secret token for accessing the table to Bitrix24 (see video)
Full access to your or test Google Table
The use case of the vgru