I want to create a zap where when a google sheet is updated with a new row of entry, a lookup list in Fastfield form gets updated with the updated google sheet values.
I don’t know what to insert in File field. I have tried publishing the google sheet and using the web link in file, but it is not working.
Anyone who has been successful creating this? please help.
+14
Hi
Can you show screenshots of all the fields to configure in Step 2 of the Zap?
We need to be able to see the field descriptions.
Hi Troy, thank you for responding back. Please see the attached:
+14
Try using the GSheet export format that is the CSV of the first GSheet tab.
Make sure the first row is headers.
Try using the GSheet export format that is the CSV of the first GSheet tab.
Make sure the first row is headers.
Would you mind explaining how can I do that? I looked into it, but could not figured it out.
Thank you. I did as suggested, but the error still persists at ‘Test Step’. See attached photos for reference. Gsheet csv link that is used.
+14
Try adjusting the File sharing preferences to be publicly accessible.
It is publicly accessible. I have even granted editor access to try it, but the error is still there.
+14
Options:
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
