Photo URL missing in Google sheets

[Kyle Ordona]

When I export Google Sheets via Apps feature in settings, the columns for photos only show the photo name. How can I get the photo URL similar to when I export the Google Sheets via Data Exports?

[Evans from Ona]

Hello Kyle, Thank you for contacting us. This is expected behaviour when connecting to Google Sheets as an app using our connector. Unfortunately, it works this way by design. To obtain links to images, you would have to prepare an export instead of connecting to Google Sheets from the apps. Please let me know if you have any further questions on this. Regards, Evans Evans Ona On Wed, Sep 18, 2024 at 09:18 AM, Kyle Ordona <ky...@thinkingmachin.es> wrote: When I export Google Sheets via Apps feature in settings, the columns for photos only show the photo name. How can I get the photo URL similar to when I export the Google Sheets via Data Exports? -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/0158ef25-71e9-407c-86ba-cd9d582fd2a7n%40googlegroups.com.

[Kyle Ordona]

Hello Evans,

Thanks for the info! Is there a workaround for this using Ona API?

[Kyle Ordona]

Hello Evans,

Thanks for the info! I made a workaround by using Google Apps Script and finding the url via https://api.ona.io/api/v1/media. Posting this here in case anyone else will encounter the same blocker

On Wednesday, September 18, 2024 at 5:10:36 PM UTC+8 eony...@ona.io wrote:

[Jenn from Ona]

Thank you for your feedback Kyle and additional information. Jenn Ona

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/454ac440-688e-4987-8253-9cc7057a6ca1n%40googlegroups.com.