FormLoom 3 exporting to Google Sheets - Error

Classic General
1

Hi All

I’m using the save to Google sheets option on Formloom 3 and it’s giving me this error msg.

Screen Shot 2016-03-08 at 11.23.04.png1013×143 3.69 KB

The details i entered are here

Screen Shot 2016-03-08 at 11.23.33.png792×349 25.4 KB

I’ve triple checked the google link for sheets and thats all good. so i know it’s not that. It send emails fine but doesn’t save it to Google Sheets.

Anyone got any advice they can give me with this.

2

@Chrisfrench

Just a guess, but don’t you have to define the spreadsheet field/header names in the google sheets and the FormLoom google sheets settings for it to properly update the Google Doc? (You are not telling the plugin where to insert the desired fields from the form into the Google Doc… imho)

Brad

3

Thanks @Turtle i did that and it was still an error status being shown.

I had HTTPS turned on before but now have turned that off for now which has made no difference communicating to Google.

More advice would be appreciated.

1 Like
4

Are you sure you’re using the Google Sheet’s FileID and not its URL? Looks like you’ve entered a URL in the image you’ve posted.

See https://yabdab.zendesk.com/hc/en-us/articles/205171855-Formloom-3-and-Google-Sheets-Setup

1 Like
5

Ill give that a go and come back to you. Hopefully that is it. Thanks @Bigsy @Turtle

1 Like
6

You have to define the field from the sheet

3 Likes