How to Use referenceData.fileKey for Inserting External Data

[Constantine]

Hello @yejin

The example of usage of this method in terms of IMPORTRANGE formula can be found here:

IMPORTANGE formula in spreadsheet

Thanks. I saw your PM, it does not contain any sensitive information, so I am providing information here. Question is related to the data that must be provided for onRequestReferenceData event. Event itself handles following parameters as in example: const link = event.data.link // Link to the source file const referenceData = event.data.referenceData // reference data for the file const path = event.data.path // A name to be displayed for external links For the setReferenceData method …

If you have questions after reading, please let me know.