Skip to main content
Question

How do I extract the value of one specific cell in Google Sheets?

  • 22 July 2024
  • 1 reply
  • 16 views

Hello! I am new in Zapier. I need to create a database in Fibery based on documents stored in a Google Drive folder.

Each document is a spreadsheet. Each document has a header with information about the document (screenshot attached).

I need Zapier to extract the value from one specific cell and update the value in a specific attribute of an entity in the Fibery database. 

So in the end I will have a  folder with Purchase Request and database in Fibery, and in database, for example, I will have Date of Requered field, which is connected to F13 cell in the spreadsheet.

Thank you for help!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Onega 

Since the GSheet is not structured as a flat file with row 1 as headers, that means the GSheet API would have to be used:

https://developers.google.com/sheets/api/guides/concepts