Google Sheet Onesignal Integration Error

[quoramedia]

What we want to do:
I want to send Photo post with text from Google sheet to Onesignal daily at a specific time.

Issue
Receiving below error. Screenshot given

Google sheet link:

Google sheets to Facebook post Pabbly

Sheet1 Post Message,Image URL,WebURL Bihar Current Affairs [High Quality],<a href="https://drive.google.com/uc?id=1aWZGPhodw2qo-h0XH383iVs410lF3JGY">https://drive.google.com/uc?id=1aWZGPhodw2qo-h0XH383iVs410lF3JGY</a>,<a href="https://mindplan.in/product/free-bihar-current-affairs/">https://mind...

docs.google.com

(You have editor access)​

Request you to change the Workflow steps and make this work.

 

[Pabblymember11]

Hey @quoramedia

Please read the help text of the action step carefully, you haven't passed the headline in the correct format as mentioned.

Though we have corrected it and it should work now.

 

[quoramedia]

Its not sending the push notification still.

Something is missing. Kindly help.

 

[quoramedia]

App ID, keys everything is correct. Rechecked.

Still its not sending the push notification.

Kindly fix this.

 

[Pabblymember11]

Can you please pass the Google Drive image URL in the direct drive URL format?

Google sheets to Facebook Photo Post not working

What we want to do: I want to send Photo post with text from Google sheet to Telegram daily at a specific time. Issue The steps with Google sheet integration is not returning correct values. Screenshot below Google sheet link...

forum.pabbly.com

 

[quoramedia]

The URL format and the drive link generater you have shared is not working. Below URL format worked.
https://drive.google.com/uc?id=1jR_o0tfea-LFJbVripFH-EG1EWgTuLEW

Please be careful while guiding clients. We just wasted 3 hours because of this misguidance.

 

[Pabblymember11]

Kindly try passing the direct Image URL of Google Drive with the following.

https://drive.google.com/uc?export=download&id=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

The ID for your Google Drive URL is - 1jR_o0tfea-LFJbVripFH-EG1EWgTuLEW